DSXchange

Hi,

I want to get a negative value of a decimal field.

MY input is 1112223334567822.22
I want output as - 1112223334567822.22

For this i gave output as -1*input

but i am getting output as -1112223334567822.24 instead of -1112223334567822.22

When i am using NEG function i am facing same problem


Please help me

Thanks for ur help

Regards

Swathi S

Try Abs(input)
If it doesnt work, try this

if input > 0 then input * -1 else input

What is the data type of the input field and of the output field? Search DSXchange for discussion of how/why floating point numbers can not be stored to full accuracy in computers.