How to make 2016 bar divide by 4 instead of 12 ?

paulyeo11 — Wed, 11 May 2016 13:06:08 GMT

Hi All

I have a chart expression from sunny which is working fine on my GL stand alone table, using below expression :-

Money(
Sum(Aggr(RangeSum(
Above(RangeSum(Above(Sum({<year, month , GL_CODE = {50010}>}[Amount]*1), 0, RowNo()))),
-Sum({<GL_CODE = {50010}>}TOTAL Aggr(Sum({<year, month, GL_CODE = {50010}>}[Amount]*1), YearMonth))), (YearMonth, (NUMERIC, DESCENDING))))/Count(distinct YearMonth)
, $(vMoneyFormatK_GL))

I try to using the same expression for my another QV doc , it display wrong value on 2016 bar.

May i know how to make it display as 1,373,000 ? ( Ref to Table 1 if add up 2016 jan till April amount divide by 4 = 1,373,000)

Now it display 457,799 because it all up 2016 stock and divide by 12. which is wrong.

it should be divide by 4. May i know how where to change ?

I will enclosed my QS Doc in my next posting.

Paul

Re: How to make 2016 bar divide by 4 instead of 12 ?

paulyeo11 — Wed, 11 May 2016 13:35:04 GMT

my QVF

Re: How to make 2016 bar divide by 4 instead of 12 ?

paulyeo11 — Wed, 11 May 2016 13:35:38 GMT

Hi All

eDIT :- I notice some thing very interesting , when i manually filter GL_CODE = 50010 , the 2016 bar become okay. why ? ( But when i not select GL_CODE =50010 the 2016 become wrong )

topic Re: How to make 2016 bar divide by 4 instead of 12 ? in App Development

How to make 2016 bar divide by 4 instead of 12 ?

Re: How to make 2016 bar divide by 4 instead of 12 ?

Re: How to make 2016 bar divide by 4 instead of 12 ?