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?
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...
in the stright table goto Numbers tab and select the Particular expression and in the number format settings select the fixed to 2 decimal.
Now i am getting extra zeros. How can i hide it?
Retrieving data ...