show a quantity in millions $ ( for example, if i have $5600000, to be shown as $5,6M)

[Nemo1]

hello, 

how can i do that? 

lets say i have a diagramm showing costs in million of $, but instead of having them represented like this: $ 7800000, i wanna have them like this: $5,8M

thanks!

[Fabiano_Martino_Intelco]

Hello @Nemo1 ,

I suggest this formula

=Num(Sum(<Expression>)/1000000, '#,### M', '.', ',')

Note: the number format if for North America, with "." for decimal separation and "," for thousand separation.

Regards

Fabiano

[Nemo1]

it is not working, the formula looks like this at the end:

Num(Sum({<Store={'AME'}>} Sales) / 1000000, '#,### M')

maybe the problem lies in the fact that i am in europe, and not in the US?

[Fabiano_Martino_Intelco · Accepted solution]

Correct.

With European formats you need to change the formula.

In my test I used:

=Num(Sum(KM)/1000000, '#.### M', ',', '.')

For your formula I suggest:

Num(Sum({<Store={'AME'}>} Sales) / 1000000, '#.### M', ',', '.')

Fabiano

[Nemo1]

accidentaly i pressed to accept the solution, it is still not working, i dont get the M 😞

[BawejaMedia]

To represent costs in millions of dollars in the format "$5.8M" instead of "$7800000", you can follow these steps:

1. Divide the Cost by One Million: First, divide the cost value by one million to convert it to a decimal. For example, if the cost is $7,800,000, divide it by 1,000,000 to get 7.8.

2. Format the Decimal as "M": Once you have the decimal value representing millions, append "M" to indicate million. So, 7.8 becomes "$7.8M". Also, check out Baweja Media.

[Nemo1]

I have already divided by 1000000, i dont know how to append the M 

[Fabiano_Martino_Intelco]

I tried to simulate your problem, but always got the M. (I also tried with a set expression).

Which version of Qlik Sense are you using?

Can you post a picture of the resulting graph?

Regards

Fabiano