Rolling Period Is not working

[priyarane]

Hi Community,

Below expression is not showing rolling period, can some one pls suggest.

Sum(Aggr(If(Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'}>} ED) -
Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'}>} COLL_AMOUNT)>0,
Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'}>} ED) -
Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'}>} COLL_AMOUNT)),
LEV_NETTING_18))

-Priya

[priyarane]

Hi Sunny, we have another way which you have give me the solution before. But now it is not working. Please check on below link

Not excluding Negative values

What is the wrong in below expression which is not excluding nagative values. I want negative values should be exclude with the help of(LEV_NETTING_18={"=sum(EAD)-sum(COLL_AMOUNT)>0"}), but it is not doing.

Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},LEV_NETTING_18={"=sum(EAD)-sum(COLL_AMOUNT)>0"}>} EBD) -
Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},LEV_NETTING_18={"=sum(EAD)-sum(COLL_AMOUNT)>0"}>} COLL_AMOUNT)