Number Format

[bharatkishore]

Hi All,

I have given the expression as

sum(Amount).

I am getting the value as 3768579921.16

Now i need to get value as integer with dollar symbol and i have given expression as

num(Sum([LC2 Amount]),'$ #,##0').

After giving this expression i am getting the value as $3,768,579,921

But now my requirement is in need to get the above value as

$37.16(round with two decimals and numbers in millions).

Hope you got it..

Num Format

[bharatkishore]

Hi Kaushik,

My expression is

=Money(Round(num(Sum({<[Ageing Buckets]={"Current"},[Clrng doc]={"*"}>}[LC2 Amount]),'$ #,##0')/1000000, .01))

Is there any modifications i need to do

[kaushiknsolanki]

Hi,

It will be as below.

num(Floor(Sum({<[Ageing Buckets]={"Current"},[Clrng doc]={"*"}>}[LC2 Amount])/1000000) +

(Sum({<[Ageing Buckets]={"Current"},[Clrng doc]={"*"}>}[LC2 Amount])

- Floor(Sum({<[Ageing Buckets]={"Current"},[Clrng doc]={"*"}>}[LC2 Amount])) ),'$ #,##.00')

Regards,

Kaushik Solanki

[bharatkishore]

Thanks a lot Kaushik