If Then Statement with Division

[hendricksk]

I have an IF Then statement that needs a division with an integer but I can't get it to work.

IF StartsWith([Tag], "SLF") THEN [PRICING]/5 ELSE [Pricing] ENDIF

The formula doesn't like the number 5. Any ideas?

[cpet13 · Accepted solution]

@hendricksk  check if the variable Pricing is set to be a numeric data type. If it is set to be a string, it can't do a division function. It may not be the 5 it does not like, but the PRICING variable. Use ToNumber([PRICING])/5 instead of just [PRICING]/5 ELSE ToNumber([PRICING]).

[hendricksk]

Thank you so much! That worked perfectly!