What is expression to convert 10,00,000 into 1 million and 100,000,000 into 100 million

[dhavalvyas]

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

[arvind_patil]

HI Dhaval,

Please add below code into your expression:

COUNT(POLICYNO)/1000000

Thanks,

Arvind patil

[ramyasaiqv]

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.

[devarasu07]

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,

Re: Number formatting - millions to billions