topic Re: QS number format set to Auto why one chart auto display in million ? in App Development

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

paulyeo11 — Tue, 14 Jun 2016 12:54:24 GMT

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

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

florentina_doga — Tue, 14 Jun 2016 13:15:54 GMT

see this

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

/1000000)

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

paulyeo11 — Tue, 14 Jun 2016 13:25:53 GMT

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 ?