Num Format

[bharatkishore]

Hi,

I have the following number

expression i have written is

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #,##0')

But i need output as

$37.16.

Can you guys please help me on this

Thanks,

Bharat

[Chanty4u]

did u tried

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #.#0')

Money#([urfield])

[avinashelite]

Did not get your requirement ...could you elaborate more...

you need to round of the values to thousand or laks ?? how 

[bharatkishore]

Hi Chanty,

I have tried this but i am getting the value as

3768579921.16(without comma)

[avinashelite]

if you need the comma try like this

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ ###,###,###,###,###,##0')

[Digvijay_Singh]

Try like '$ ##,#0.00'

[bharatkishore]

Hi Avinash,

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..

[bharatkishore]

I tried your expression Digvijay but the first numbers should be only 2 numbers instead of 6 to 7 integers.

[Digvijay_Singh]

=num(3768579921.16/100000000,'$ ##.00')

[jagan]

Hi,

Try this

num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #,##0.00')

Regards,

Jagan.