This topic contains 5 replies, has 0 voices, and was last updated by Claz 7 years, 11 months ago.
-
AuthorPosts
-
jimk- Contributions: 0
- Level 1
- ☆
We have a saved search that has two columns that are formula fields that are essentially revenue and cost. I'd like to have another formula field for profit – e.g. revenue-cost. Is this possible?
This is a cached copy. Click here to see the original post. -
torin@aminian.com- Contributions: 0
- Level 1
- ☆
You should be able to. The setup of this new formula depends on the revenue and cost formulas you mentioned. Could you post those formulas?
-
jimk- Contributions: 0
- Level 1
- ☆
Yes. Both are Formula (Numeric) and summary type Sum. It is a transaction search.
Revenue:
Code:
case when {account.name} = 'Sales : Sales – Merchandise' OR {account.name} ='Sales Returns & Discounts : Returns/Damage Claims' then {netamount} else 0 end
Cost:Code:
case when {account.name} = 'Cost of Goods Sold : COGS – Merchandise' then {grossamount} else 0 end
I found that if I treated the case statements as revenue and profit – e.g.Code:
(case when {account.name} = 'Sales : Sales – Merchandise' OR {account.name} ='Sales Returns & Discounts : Returns/Damage Claims' then {netamount} else 0 end)- (case when {account.name} = 'Cost of Goods Sold : COGS – Merchandise' then {grossamount} else 0 end)
It seems to work. However, I was hoping for a cleaner way as we might want to do more calculations with these numbers and expand on this saved search. Thanks in advance for any help. -
torin@aminian.com- Contributions: 0
- Level 1
- ☆
That's exactly what I would have done. I don't see this formula being set up in a different way unless someone else has some input.
You could look into enabling the gross profit feature. But this is not retroactive (it would only affect transactions moving forward).
-
rsm_ryan_meyer- Contributions: 0
- Level 1
- ☆
The new reporting engine will supposedly be able to do this, but as of right now, you're stuck recreating the revenue and cost formulas in the net income formula. You can't currently have the Net Income formula be {revenueformula}-{costformula}.
-
Claz- Contributions: 0
- Level 1
- ☆
I don't believe it is possible. It looks like you want something similar to that avialabe in SuiteFlow. You can create stage-level or workflow-level fields. Elsewhere – but within the workflow – you can populate and refer to those fields. You could create [or have your admin do it for you] a transaction field and save values into it. Then its ready for you to use in your saved search – exactly as you wish to use it?
-
AuthorPosts
You must be logged in to reply to this topic.