Whats wrong with this simple AGGR()?

[#1]

Can some one please help me and explain whats wrong with the AGGR statement below. I tried working around this statement changing the functions, but its no use. I have total values at month level and unable to get the running totals using the AGGR(). I just have 4 months data. Its really annoying me for sometime now.

sum(aggr(sum(vLastFctPayment.Amount)-(sum(Expenses.Expenses)-sum(vLastFctPayment.ServicingFee)),Calendar.YearMonth))

I have above expression within a variable called $(vCashToMonth) and I even tried aggr($(vCashToMonth), Calendar.YearMonth) still doesnt work.

Thanks a ton in Advance,

Mady

[swuehl]

Hi,

are you using variables within your aggr? (Just thinking because of the 'v' at the beginning of field Names)

If so, what do they look like?

If not, the expression look good to me, could you post a small sample app here?

Regards,

Stefan

[erichshiino]

Does it work if you select only one Calendar.YearMonth?

Does it work without Aggr ?  (sum(vLastFctPayment.Amount)-(sum(Expenses.Expenses)-sum(vLastFctPayment.ServicingFee))

[#4]

Hello Erich,

yes it works for one Calendar.YearMonth and even the expression works normally if I dont add AGGR. But when I use it in a pivot or else where I have problem without the AGGR().

I have a sample, just not sure how to attach a QVW here. Its a real pain.

Can you please help?

Thanks

Mady

[#5]

Sample attache now, please check the first post.

Thanks,

Mady

[lironbaram]

hei

try this one

hope its helps you

[#7]

Hello Liron,

I am sorry but I was trying to get the running totals, and in your attachment it looks like, its not working. Please correct me if I am missing something here.

Thanks again for your effort.

[lironbaram · Accepted solution]

ok

you are correct

try this one

[swuehl]

Lirons solution looks ok, to me.

An alternative using rangesum:

=rangesum(before(sum(Amount),0, columnNo()))

Please take care, if you change the pivot orientation (Year-Month vertical instead of horizontal) you must replace before() with above() and columnNo() with rowNo().

[#10]

Hello Liron,

Thankyou for the help and I think I am getting what I wanted, But what if the expression for month calculation is

sum(Amount) - (sum(Expenses)-sum(vLastFctPayment.ServicingFee) ) how do I add this to the formula which is suggested by you here as seen:

=sum(Amount)+if(isnull(after(sum(Amount))),0,after([Amount1]))

Thanks Again,

Mady