Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did u tried
num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #.#0')
Money#([urfield])
Did not get your requirement ...could you elaborate more...
you need to round of the values to thousand or laks ?? how
Hi Chanty,
I have tried this but i am getting the value as
3768579921.16(without comma)
if you need the comma try like this
num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ ###,###,###,###,###,##0')
Try like '$ ##,#0.00'
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..
I tried your expression Digvijay but the first numbers should be only 2 numbers instead of 6 to 7 integers.
=num(3768579921.16/100000000,'$ ##.00')
Hi,
Try this
num(Sum({<[AB]={"Current"},[CD]={"*"}>}[Amount]),'$ #,##0.00')
Regards,
Jagan.