Format number - percent (How to keep two decimal places accuracy)

LilCLilC Member Posts: 24 Learner I
edited July 2020 in Help
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.  
 

Tagged:

Best Answer

  • LilCLilC Member Posts: 24 Learner I
    Solution Accepted
    Solved: I just realised that I can use the pattern as 0.000%
Sign In or Register to comment.