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: 
Not applicable

Rounding

Hi All,

I am working with a straight table where i need to round some values from

100,000,000.00 to 100.00

AND

if value is only two decimal palaces 0.11 no action is needed.

How can I work this into a formula?


Thank you

9 Replies
Not applicable
Author

Hi,

Try something like this:

=num(sum(Expression),0.00)

Regards,

-Khaled.

Not applicable
Author

Pl upload the application

shree909
Partner - Specialist II
Partner - Specialist II

Try this

=round(sum(Expression),0.01)

it will round the values and display with 2 decimals

or if u want to list the first 2 decimals.

Goto the properties tab, select numbers theere u can modify the values accordingly..

or   =num(sum(Expression),0.01),' #,##0.00') it will exactly return 2 values...

Not applicable
Author

That does not work for me. Any other suggestions?

shree909
Partner - Specialist II
Partner - Specialist II

can u post a sample .so that we can figure out where exactly ur missing?

Not applicable
Author

Dear zvirina123,

in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.

Thanks,

Mukram.

Not applicable
Author

Here you go. Thank you for your help

shree909
Partner - Specialist II
Partner - Specialist II

where exactly ur getting wrong..

i am able to display for the 2 decimals..

the thing is u marked in numbers as money format..

can u change that to decimal...

Not applicable
Author

Now i am getting extra zeros. How can i hide it?