Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Try this with money function
=Money( Round( num(Sum( 3768579921.16),'$ #,##0')/100000000, .1),'$ #,##0.00')
Regards
Anand
Try this
=Round( num(Sum( 3768579921.16),'$ #,##0')/100000000, .01)
Regards
Anand
Hi Anand,
Tried your solution but not able get my requirement..
how you get 37.16 what is the calculation.
Regards
Anand
Hi
try with money() function..and just the values in the number format tab...
Sorry Anand.. I got the solution what you have given is correct.. But i need to display dollar symbol also...
Hi,
Try this.
num(Floor(sum(Amount)/1000000) + (sum(Amount) - Floor(sum(Amount)) ),'$ #,##.00')
Regards,
Kaushik Solanki
Try this with money function
=Money( Round( num(Sum( 3768579921.16),'$ #,##0')/100000000, .1),'$ #,##0.00')
Regards
Anand
Everything is fine except the total. Here the "total values" are coming as 339.56 and remaining comes as 34.12. Is it possible to change the "total values" as 33.56
Hi,
Try the one which I gave you.
Regards,
Kaushik Solanki