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?
Solved! Go to 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]).
Thank you so much! That worked perfectly!