Simple division percentage equation, but only if {Rebate Amount}>0. I am getting the proper calculations for other rows but the rows where {Rebate Amount}=0 I get invalid parameter.
I have tried:
IF({Deal Type}=“Standard”,0,{Reb Rec’d}/{Rebate Amount}*100)
IF({Rebate Amount}>0,{Reb Rec’d}/{Rebate Amount}*100,0)
IF({Rebate Amount}<>0,{Reb Rec’d}/{Rebate Amount}*100,0)
I have also done all the above using the divide function instead of just {Reb Rec’d}/{Rebate Amount}
I feel it must be something with roll ups, dividing by zero, or a text vs. number issue?
