This topic contains 5 replies, has 0 voices, and was last updated by Claz 7 years, 11 months ago.
-
AuthorPosts
-
November 23, 2016 at 2:29 pm #23042
jimkWe 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. -
November 23, 2016 at 3:13 pm #23043
torin@aminian.comYou should be able to. The setup of this new formula depends on the revenue and cost formulas you mentioned. Could you post those formulas?
-
November 23, 2016 at 3:17 pm #23044
jimkYes. 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. -
November 23, 2016 at 3:29 pm #23045
torin@aminian.comThat'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).
-
December 6, 2016 at 10:01 pm #23046
rsm_ryan_meyerThe 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}.
-
December 7, 2016 at 2:53 am #23047
ClazI 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.