Using beast mode to determine att rate

major_ace

I'm trying what seems like it should be a simple calculation, but I'm getting either an illogical result or an error.

Scenario:

If opportunity has services sold(ie >0), then calculate the % by dividing sold svcs by total deal amnt.

In the table below, it would be 1250/2510, not 1250/5045

CASE

WHEN SERVICES >0 THEN SERVICES/ DEAL_AMT

END

thanks in advance to the gurus

RobSomers

@major_ace

Try:

case when IFNULL('Services',0)>0 then 'Services'/'Deal_Amt' end

Your blank services amount fields are probably null not blank and nulls don't play nice with logic operators.

major_ace