Avg(Aggr) not working

[#1]

Hi,

I have a expression, which works fine:

sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Fee]) /

sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Principal])

Now I want to take the avg for a time period.

So I wrote my expression as:

avg(aggr(sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Fee]) /

sum({<[Report Date]={">=$(=Date(Yearstart(Max([Report Date]))))<=$(=Date(Max({<DateFlag = {2}>}[Report Date])))"}>}[New Issuance Principal]), [MonthName of Year]))

Although it doesn't show any error but my values for first and second expression remain same. Can someone tell me whats wrong with my expression.

I'm using MonthName of Year as my dimension.

Thanks for all the help.

Regards,

Aditya

[sunny_talwar]

The change you have made would only change a number for a total. Are you expecting a change in the rows of your chart? Actually the question to ask here is, are you doing this in a chart or text box object?

[#3]

Hi Sunny, I'm doing it in a chart.

[sunny_talwar]

Would you be able to share a sample with your expected output?

[#5]

Sure Sunny. I'll attach the sample in a new thread and tag you onto it.

[sunny_talwar]

Sounds good

[#7]

Done, sent you the qvw.

Issue with avg(aggr)

Thanks for all the help..