Calculation for in month using set analysis

[#1]

I have a statement which calculates the delayed orders as below;

Sum(Aggr(If((inLeveransDatum - Lev_Leveranstid)> Villkor_inlev, 1, 0), [%InLevNr]))' with month as dimension.

i wish for this statement to be for the previous month in a table without the month dimension but my syntax is incorrect

any help would be greatly appreciated;

Sum(Aggr{<inLeveransDatumMonth={'>=$(=max(inLeveransDatumMonth)-1)<=$(=max(inLeveransDatumMonth)-1)'}>} If((inLeveransDatum - Lev_Leveranstid)> Villkor_inlev, 1, 0), [%InLevNr]))

Best

Brad

[#2]

Brad,

Aggr does not accept the set analysis. Sum does.

So I would move the Set Analysis statement into the the Sum section.

Fabrice