Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hschultz
Partner - Creator
Partner - Creator

Money rounding cents to .00

Hi All

I cannot understand why my cents are being rounded to .00

When i select Number, 2 Decimals a figure will show (for instance) 123.50. But as soon as i make it Money, it shows as 124.00

This is the formula in the chart is this:

R # ##0.00;R-# ##0.00

Can anyone please advise what i am doing wrong?

1 Solution

Accepted Solutions
giakoum
Partner - Master II
Partner - Master II

It is because it has a comma still as a seperator. Change comma to dot and it will work.

BR, Ioannis

View solution in original post

19 Replies
flipside
Partner - Specialist II
Partner - Specialist II

Hi,

Are you selecting "Number" or "Fixed to" on the Number tab?  "Number" will set the value to a precision of 2 and not 2x decimal places which is set by "Fixed to".

In either case can you not use the "Money" setting?

flipside

giakoum
Partner - Master II
Partner - Master II

It looks like it is working correctly for Euro.

What is your windows settings?

Please check attached file.

hschultz
Partner - Creator
Partner - Creator
Author

I want to use money, but it rounds to xxx.00.

Just for testing i used fixed 2 decimal, and then it is the right amount.

But i want it to be money, yes

hschultz
Partner - Creator
Partner - Creator
Author

Hi there. Your sample works on my machine. And my number settings are the same.

hschultz
Partner - Creator
Partner - Creator
Author

..So i don't understand what could be different in my model?

giakoum
Partner - Master II
Partner - Master II

you need to post a sample application.

hschultz
Partner - Creator
Partner - Creator
Author

I need to head out now, but i will see if i can make 1 tomorrow and upload

flipside
Partner - Specialist II
Partner - Specialist II

I see what is happening now.  The Money format has to have a comma in for the thousands. So in your load script or formula, change it to ...

R #,##0.00;R-#,##0.00

... and it should work when you choose Money in number properties (you might need to click System or set the format yourself so the comma appears).

I don't know if this is a bug or not, or working by design, as we use commas all the time for thousand separator in the UK.

flipside


hschultz
Partner - Creator
Partner - Creator
Author

Please see attached an example of my issue.

My system settings is the same as the QV settings.

Here is a screenshot for refferance:

Capture.PNG