Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
This is my expression =num($(vShipcurrentOnTimeAmtPct),'#,##0%')
this is the result 75,018,045%
I would like to see just 75.0% instead on whole number
Can some body help
Thanks,
Dinesh
Seems likely you're calculating % incorrectly in the variable, in which case fix the calculation, and it will be formatted correctly.
Not sure why you get that, but may be divide it by 1000,000,000
=Num($(vShipcurrentOnTimeAmtPct)/1000000000,'#,##0%')
Seems likely you're calculating % incorrectly in the variable, in which case fix the calculation, and it will be formatted correctly.