Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I took a closer look at your screnshot but I can't cleerly see;
Is your Decimal Separator (@Money) a comma( , ) or a dot( . )?
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) ?
I took a closer look at your screnshot but I can't cleerly see;
Is your Decimal Separator (@Money) a comma( , ) or a dot( . )?
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.