Formula help: Where does ToNumber() get placed

[CherylH]

HI,

Need help with a formula. Column will be used to multiple with another column reason it needs to be numeric.

Data Type=Double 8  & Formula is colored correctly and reads:

IF [BB File]="Y" THEN [Product Rebate] ELSEIF [BB File]="PB=50% balance to allied" and [Reporting  Bottler System]="PB" THEN [Product Rebate]/2 ELSE "0" ENDIF

error comes up= The Formula resulted in a string but the field is numeric.  Use ToNumber() if this is correct. 

Where do I insert: ToNumber()  and what needs to go in the brackets?

Thanks  in advance for helping. 

[christine_assaad · Accepted solution]

Hi @CherylH 

I assume Product Rebate is a numeric field. In that case, the else statement should have 0 not "0" as the double quotes make it a string. Hope this helps. Cheers!

[CherylH]

Hi Christine,

That fixed it! So simple UGH!    Thank you so much