Why it does not aggr(rangesum) after i filter

[raceberos]

Edit1: I already upload the qvf file... for reference thanks..

Edit2: I update my formula

from: "((Aggr(RangeSum(Above(Sum({<GL2= {11}>} GLTOTAL), 0, RowNo())), BRANCHNAME, [DOCDATE.autoCalendar.Month]))  ) - ((Aggr(RangeSum(Above(Sum({<GL2= {21}>} GLTOTAL), 0, RowNo())), BRANCHNAME, [DOCDATE.autoCalendar.Month])) *-1 )"

into:

from: "((Aggr(RangeSum(Above(Sum({<GL2= {11},[DOCDATE.autoCalendar.Month]=>} GLTOTAL), 0, RowNo())), BRANCHNAME, [DOCDATE.autoCalendar.Month]))  ) - ((Aggr(RangeSum(Above(Sum({<GL2= {21},[DOCDATE.autoCalendar.Month]=>} GLTOTAL), 0, RowNo())), BRANCHNAME, [DOCDATE.autoCalendar.Month])) *-1 )"

Hi good day every one i just created a financial KPI last week with the help of some people here in our community and it was good... but after i check every details of it i notice that there is something went wrong after i filter...

the 1st chart is perfect the figure shows exactly what i want..

but after i filter a month everything went wrong...

ohh by the way this is my formula

"((Aggr(RangeSum(Above(Sum({<GL2= {11}>} GLTOTAL), 0, RowNo())), BRANCHNAME, [DOCDATE.autoCalendar.Month]))  ) - ((Aggr(RangeSum(Above(Sum({<GL2= {21}>} GLTOTAL), 0, RowNo())), BRANCHNAME, [DOCDATE.autoCalendar.Month])) *-1 )"

can some one have any idea why it happens?

thanks

Message was edited by: Reynaldson Aceberos QVF file is added

[raceberos]

yeah thanks for heads up, i realize i keep on testing on asset on January where i put my begging balance so technically  it will always return accurate result. then i check the other months then i see that it relay fail.. on selection

im still looking for the right solution...

[luismadriz]

Hi,

Do you know the right values you should be getting for each month? Have you done your calculations in Excel or something?

Cheers,

Luis

[raceberos · Accepted solution]

i update my formula into

'=Aggr(RangeSum(Above(Sum({<GLHeader= {1}, [DOCDATE.autoCalendar.Month]=>} GLTOTAL), 0, RowNo())), Branch, Month)' and now even if i select any month it will not take any effects on figures... 

thanks alot mate for helping me...

-rey