Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
How can I limit the number of decimals within my expression?
I have an expression in my chart title, which is supposed to show me 22% but I don't know how to format it, so it shows 0.2212341241 or something. I can of course multiply with 100, but I want it to round off (have no decimals, or just one is also okay).
Here is the title of my gauge chart:
='Credit Utilisation (Limit Spent) - '& Sum (Limit-[OTB (excl. oversell)])/Sum (Limit)*100
try
=num('Credit Utilisation (Limit Spent) - '& Sum (Limit-[OTB (excl. oversell)])/Sum (Limit)*100),'#,##0.00%') or Properties
Guys do you realize that this post is from 2011? They might have already solved the issue.
Just wanted to let you know if you did not already know.
Best,
Sunny
Hi Sunny,
Is there a way to round your number up to the nearest million, e.g. 2,893,754,164 so if I write it in million it should be 2,894M not 2,893M because I want to round up. But everywhere I see they suggest to divide the number by 1 million and add M at the last.
Thanks,
Anas
Ideally, you should have created a new thread for not so-much related topic help.
You can use Ceil() like: Ceil( <number> , 1000000 ) &'M'