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

LilC
LilC New Altair Community Member
edited November 2024 in Community Q&A
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.  
 

Best Answer

  • LilC
    LilC New Altair Community Member
    Answer ✓
    Solved: I just realised that I can use the pattern as 0.000%

Answers

  • LilC
    LilC New Altair Community Member
    Answer ✓
    Solved: I just realised that I can use the pattern as 0.000%