QS number format set to Auto why one chart auto display in million ?

[paulyeo11]

Hi All

I have 2 chart .

Chart 1 it will display in many digit like S5,452,661.195.02

Chart 2 it display 138.26M

Both numbering format i set to auto.

My question is why chart 2 will know to convert the amount to million ? and chart 1 does not automatic convert to million.

Paul

[florentina_doga]

see this

Above(RangeSum(Above(Sum({<year, month, GL_CODE = {50010}>}[Amount]

/1000000)

[paulyeo11]

Hi Flor

Thank you for your reply. I am aware that i can use /1000000 for make it display in million. My doubt is why both chart return different number format ? as both of expression i never add /1000000 ?