Number Symbol

[#1]

Hi

I would like o include a symbol in a my straight table chart Sum(Value) to return symbol "K" for thousands, "M" for million next to the number in the table. How can I do this?

[Colin-Albert · Accepted solution]

You will need to manually test the value and divide the value by 1000000 or 1000 then add the 'K' or 'M' within your expression.

The option on expressions for Thousand, Million and Billion symbols only work on image charts like bar or pie charts, they do not work on straight or pivot tables

[swuehl]

Maybe like described here.

Number format in espression

[robert_mika]

Try like this:

if(sum([# Air Time])<1000000,dual(sum([# Air Time]/1000)&' K',sum([# Air Time])/1000),dual(sum([# Air Time])/1000000&' M',sum([# Air Time])/1000000))

You need dual to return number.

or fallow Stefan suggestion which is very neat.

[#5]

Divide it down then add in the Mn, Bn etc in the expressions.