Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Brad,
Aggr does not accept the set analysis. Sum does.
So I would move the Set Analysis statement into the the Sum section.
Fabrice