Money format rounding up

[#1]

Hi there,

I'm finding that the Money Number format is rounding my cents up. If I use "Fixed" to 2 decimal places, the values are correct. Money showing 2 decimals is showing 0's.

Please see the below screenshots.

Fixed:

Money:

Is there anything I'm doing wrong? How can I correct this so that the Money format is precise to 2 decimal places.

Thank you!

[Anonymous]

I don't see anything wrong in your format pattern either ....
Maybe you should check how the separators are set in your counrty settings (controle panel) ?

[Anonymous · Accepted solution]

I took a closer look at your screnshot but I can't cleerly see;

Is your Decimal Separator (@Money) a comma( , ) or a dot( . )?

[#4]

Hmm... I think you're onto something. My PC regional settings bizarrely had comma as decimal separator. And so did QlikView, in my script. I've updated, reloaded and I'm sorted.

Thank you! I should have seen that. I guess the "cents" weren't being treated as decimals at all and so the 0's were being taken literally.