August 15, 2007, 06:28 PM
dreddy_23CAPTURE DECIMAL
Hi,
I am having difficulty capturing the decimal values in my result.
For example,
If the value is divisible by a constant let’s say (16/16 = 1.0 or 32/16 = 2.0 or 48/16 = 3.0 etc...) then I need to ignore the record and if the value is not divisible by the constant and I get decimal values like (20/16 = 1.25 or 100/16 = 6.25 or 500/16 = 31.25) then I need to capture this value. I only need to capture when there is a reminder value with decimals.
Please let me know if anyone has some idea?
Thanks.
August 16, 2007, 03:24 AM
PiipsterLook in the Functions Manual, Numeric functions section for:
DMOD, FMOD, and IMOD: Calculating the Remainder From a DivisionIf your remainder is 0 you will use a WHERE to exclude the row. If the remainder is not 0 then you keep the row.
August 16, 2007, 12:43 PM
dreddy_23Thank you PIIPSTER.