Number Format on Formula

[GDunn1]

Hi, I am trying to convert the output to 0.0M format. It works for other formula but not this one. The output is 0.0, not 0.0M.

num((sum({<monthkey = {">=202401<=202412"}>} Inflow) +sum({<monthkey = {">=202401<=202412"}>} InSpecieTransferIn))/1000000,'#,##0.0M')

[pravinboniface · Accepted solution]

@GDunn1 Can you please check if your number formatting property is set to Auto or Measure expression?

[GDunn1]

That fixed it ! Thanks @pravinboniface