decimal doesn't show the correct amount

[sw1202]

Good morning,
I have a report displaying the wrong decimal amount when an entry is over a million and voided. The original entry is displayed correctly on the report as $1,918,724.12, but the voided entry shows -1,918,724.10 (it is -1,918,724.12 in all tables). I set decimal to 2. I tried to format it in the report as 999,999,999.99. I also expanded the field to numeric 13,2 instead of 12,2. Nothing helped.
Please help! Thank you.
SW

 

[GriffMG]

Is the control linked to a field in a cursor or table, or is it calculated?

Have you tried setting the format to have 3 decimal spaces?



Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

I'm trying to cut down on the use of shrieks (exclamation marks), I'm told they are !good for you. ​

 

[sw1202]

Thank you for such quick reply. I have been trying everything I could think of. It's linked to a field in a table. And they don't want three decimals on the reports.

 

[sw1202]

Griff,
I went back and set the format to have 3 decimals and it shows -1,918,724.100 .
SW

 

[sw1202]

Griff,
Rereading your reply, I went back to check and it does have a cursor at the beginning (that data got copied from a table to) and it is n(10,2). I changed it to 12,2 and that fixed it. Thank you so very much.
Have a nice day.
SW

PS. I searched for all cursors and made sure they are all 12,2 now Thanks again.