Expression help

[#1]

Hi all,

I got the following expression:

sum(aggr(rangesum(above(total sum({< Year = {$(=(max(Year)))}, DivisionName = {'XXXX'}, TodoSubtype = {'AB'}>} RevenueAmount/(1+Sales.Red)),0,4)),Week))

Now this should give me a 4 week average but it isn't. I tried moving my (()) but can't figure it out. Somebody got a clue what I'm doing wrong?

like week 4 gives a average over the past 4 weeks.

kind regards

[MK_QSL]

Try

SUM(Aggr(RangeSum(Above(Total SUM({<Year = {‘$(=Max(Year))’}, DivisionName = {'XXXX'}, TodoSubtype = {'AB'}>}RevenueAmount),0,4),Week)))

RangeSum(Above(Total SUM({<Year = {‘$(=Max(Year))’}, DivisionName = {'XXXX'}, TodoSubtype = {'AB'}>}RevenueAmount),0,4)

[#3]

hmm Both aren't me showing any data.

SUM(Aggr(RangeSum(Above(Total SUM({<Year = {‘$(=Max(Year))’}, DivisionName = {'2WIN'}, TodoSubtype = {'AB'}>}RevenueAmount)),0,4),Week))

It only gives me the number 4. Instead of a 4 weeks total.

[tresesco]

Could you post your sample qvw?