This topic contains 5 replies, has 0 voices, and was last updated by Claz 7 years, 11 months ago.

  • Author
    Posts
  • #23042

    jimk

    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.

  • #23043

    torin@aminian.com

    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?

  • #23044

    jimk

    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.

  • #23045

    torin@aminian.com

    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).

  • #23046

    rsm_ryan_meyer

    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}.

  • #23047

    Claz

    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?

You must be logged in to reply to this topic.