topic Money format rounding up in QlikView

Money format rounding up

Thu, 27 Jan 2011 10:14:56 GMT

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!

Money format rounding up

Anonymous — Thu, 27 Jan 2011 11:56:47 GMT

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) ?

Money format rounding up

Anonymous — Thu, 27 Jan 2011 12:00:17 GMT

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

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

Money format rounding up

Thu, 27 Jan 2011 12:06:59 GMT

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.