Discussion Board for collaboration related to Creating Analytics for QlikView.
I am working with a straight table where i need to round some values from
100,000,000.00 to 100.00
if value is only two decimal palaces 0.11 no action is needed.
How can I work this into a formula?
Try something like this:
Pl upload the application
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...
That does not work for me. Any other suggestions?
can u post a sample .so that we can figure out where exactly ur missing?
in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.
Here you go. Thank you for your help
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...
Now i am getting extra zeros. How can i hide it?