i am using this number formatting, $#,##0,,M;-#,##0,,.0 M, which gives me $56,986 M
i am trying to get $56.9 M i cant seem to adjust it or know what to tweak, can you assist
If you want to display value as millions, you can try below formatting:
the number is 56985648.52, id like to make it $56.9M i am trying to do a custom
Below Setting will round off the number.
If you don't want to round off, you can try below logic:
Output = "$"+LEFT((STR([Value]/1000000)),(FIND(STR([Value]/1000000),'.'))+1) +"M"
Retrieving data ...