Converting money into Symbol

[Anonymous]

Hi All,

How to convert amount into million ,billions in straight table. In number tab Symbol option is not enabled after selecting the inter option also.

Please Help me.

Thanks in advance.

[morganaaron]

Write it into a Num() expression, like:

If(Sum(Sales)>1000000000, Num(Sum(Sales)/1000000000, '##0.00B'), Num(Sum(Sales)/1000000, '##0.00M'))

Which would give you your data in billions or millions.

[#3]

Do this,

Properties ->Number->

Select the relevant expression-> (you want the result)

Select Integer(mark)

Then,

Apply-> Ok

Priyantha.

[jagan · Accepted solution]

Hi,

In Straight table this options will be disabled, since straight table do not have X and Y axis.  If you want this you have to do this manually like below

=If(Sum(Measure) > 1000000000, Num(Sum(Measure)/1000000000, '##0.00B'),

     If(Sum(Measure) > 1000000, Num(Sum(Measure)/1000000, '##0.00M'),

     Num(Sum(Measure)/1000, '##0.00K')))

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Thankyou  Jagan Mohan and aaron Morgan

[jagan]

Hi Anusha,

If you got the Answer close this thread by giving Correct Answer to the useful post.

Regards,

Jagan.

[#7]

what if i have multiple measures like combination chart

[jagan]

Add some additional conditions to the If().

Regards,

Jagan.