Yeah, i have a figure $12,807,980 in a text object. I am able show the figure pattern of this value as such "=num(Sum(sales), '$#,##0')".
But Now, i want it to be show as $12.81M ? How can I do that in a text object?
=If(Sum(Sales) / 1000000 > 1, Num(Sum(Sales) / 1000000,'$#,##0') & 'M', Num(Sum(Sales),'$#,##0'))
thanks! this is the longest . i will try it out as well. thanks!
It is the longest but with other solutions in sum is less than 1M you will have $0.34M while with my solution you will have $340000
Hi Jim, hope this helps:
Thanks, i have tried yours. It solved my issue!
goto-->properties-->number-->here change the number format
this is also 1 of the solution. however, i am using a text object, there is not number tab. Thanks anyway!
Retrieving data ...