Hi, doing a saved search for our B2B team to calcu...
# general
m
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?