I am pulling data from a MS SQL Server table that includes numbers in millions: $15,000,000.00, for example.
How do I get that number to render as $15.0 M across all the Qlik Sense charts in my app? From the help documentation, it appears some charts require a calculation to be applied, some charts require a custom number format $x,xx0.0 M to be applied, and some charts are not responding to either approach.
How do I consistently get that number to show as $15.0 M across all the Qlik Sense charts in my app?