Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Suppose I have count of policyno is 10,00,000
1> I want it in million, i.e. 10,00,000 = 1 million.
Suppose I have count of policyno is 100,000,000
1> I want it in 100 million, i.e. 100,000,000 = 100 milloin
My expression is COUNT(POLICYNO)
so how to modify expression for a
HI Dhaval,
Please add below code into your expression:
COUNT(POLICYNO)/1000000
Thanks,
Arvind patil
Hi Dhaval,
Try setting it on the "Number" tab of the Chart.
Chart Properties-Number- Million Symbol.
Attached screen shot for reference. Hope this helps.
Hi,
You can try like this in your expression,
=If(Count(POLICYAMT)/100000000 > 1,Num(Count(POLICYAMT)/100000000,'$#,###Billion'), Num(Count(POLICYAMT)/1000000,'$#,###million'))
Best solution will be @Macro suggestion at back-end script method,