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

[its_anandrjs]

Try this

=Round( num(Sum( 3768579921.16),'$ #,##0')/100000000, .01)

Regards

Anand

[bharatkishore]

Hi Anand,

Tried your solution but not able get my requirement..

[its_anandrjs]

how you get 37.16 what is the calculation.

Regards

Anand

[nagireddy_qv]

Hi

try with money() function..and just the values in the number format tab...

[bharatkishore]

Sorry Anand.. I got the solution what you have given is correct.. But  i need to display dollar symbol also...

[kaushiknsolanki]

Hi,

Try this.

num(Floor(sum(Amount)/1000000) + (sum(Amount) - Floor(sum(Amount)) ),'$ #,##.00')

Regards,

Kaushik Solanki

[its_anandrjs · Accepted solution]

Try this with money function

=Money( Round( num(Sum( 3768579921.16),'$ #,##0')/100000000, .1),'$ #,##0.00')

Regards

Anand

[bharatkishore]

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

[kaushiknsolanki]

Hi,

Try the one which I gave you.

Regards,

Kaushik Solanki