Text Object. Num query / rounding up

[knightwriter]

     Hi All,

I have created a text box object to a sum a number in USD. I can get the sum to work and I have inucluded =num(sum(sales), '$##,###.')

How do I round this number up? ie $31,123,123 to $31m?

Many thanks

[sunny_talwar · Accepted solution]

May be this:

=Num(Sum(sales)/1000000, '$##,###.') & 'm'

[sunny_talwar]

Or may be this:

=Dual(Num(Sum(sales)/1000000, '$##,###.') & 'm', Num(Sum(sales), '$##,###.'))

[knightwriter]

Ah yes! Didnt even think to /1000000!

Thank you sunindia

[sunny_talwar]

No problem.

Glad I was able to help.

Best,

Sunny