Hi, doing a saved search for our B2B team to calculate Gross Margin per deal. I've setup the following formula, but it returns "ERROR: Possible Divide by Zero"
((((((case when {accounttype} = 'Income' then {grossamount} else 0 end) - case when {accounttype} = 'Cost of Goods Sold' then {grossamount} else 0 end)))) / (case when {accounttype} = 'Income' then {grossamount} else 0 end) )*100
Any thoughts?