Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
Maybe like described here.
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.
Divide it down then add in the Mn, Bn etc in the expressions.