how to check if a number is whole or not.

koderman

I have an IF statement that I want to do but I cannot seem to get it to work. What would be the best way to solve this or am I going about this all wrong? My statement is "IF quantity/"Sales Quantity" = (any whole number) THEN BEGIN..." or I could use "IF quantity/"Sales Quantity" <> (contain '.' or a decimal number) THEN BEGIN..."

Juha

you can use ROUND with precision=1.
IF decimalValue = ROUND(decimalValue,1) THEN BEGIN..

Phenno

You can use MOD or DIV C/AL operator.
If qty MOD sales qty = 0

Juha

you can use ROUND with precision=1.
IF decimalValue = ROUND(decimalValue,1) THEN BEGIN..

Phenno

You can use MOD or DIV C/AL operator.
If qty MOD sales qty = 0