Skip to Content
0
Former Member
Mar 12, 2007 at 10:34 AM

negative function not working properly.

26 Views

Hi,

We have a problem when we want to invert an amount field. When we want to have the negative value of 192850,01 we use the NEG function and XI then returns 192850,02-.

If we use MUL (multiply) by -1 we have the same problem. Since these are financial bookings these figures have to be exactly correct.

The problem only occurs when we have two decimal places.

The problem disappears when the amount field is lower than 131071,00

Seems like a bug. Anyone notice this too?

Note we're still on SP15

Regards

Tom