Using beast mode to determine att rate

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



Answers

  • @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.

    **Was this post helpful? Click Agree or Like below**

    **Did this solve your problem? Accept it as a solution!**

  • major_ace
    major_ace PHX, USA ⚪️