Options
Format number - percent (How to keep two decimal places accuracy)
I use a macro to sum up sales and generate as sales / eval(%{SumSales})
The ideal outcome is to get a percentage, so I use Formate Number - percent after this.
But the problem is it only shows 1%, 2% etc..
How to keep two decimal places accuracy like 1.23%, instead of just 1%...
Thanks a lot, guys.
The ideal outcome is to get a percentage, so I use Formate Number - percent after this.
But the problem is it only shows 1%, 2% etc..
How to keep two decimal places accuracy like 1.23%, instead of just 1%...
Thanks a lot, guys.
0
Best Answer
-
OptionsLilC Member Posts: 24 Learner ISolved: I just realised that I can use the pattern as 0.000%0