I am trying to format the data to show in millions on most occasions. The AUTO format doesn't always display it that way and I want to force the display.
Is there a way?
Divide your value by 1000000 and apply this custom format : # ##0,00 M
Thanks - I was hoping for something cleaner, but will do that.
Thanks for the help.
Please mark answers as Correct or Helpful, so that others in the community know if the thread needs more attention or not.
Try formatting with Num() like below
=Num(Sum(MeasureName)/1000000, '#,##0.00 M')
Hope this helps you.
Please check this Steps to Change : Qlik Sense - Billions number format 'G' to 'B'
Retrieving data ...