Not excluding Negative values

[priyarane]

Hi Community,

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)

Can some one pls suggest

-Priya

[kaushiknsolanki]

Hi,  Try this

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)

Regards,

Kaushik Solanki

[MK_QSL]

May be this...

Sum(

  {<

  %YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},

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

  >}

EBD)

-

Sum(

  {<

  %YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},

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

  >}

COLL_AMOUNT)

[priyarane]

Not working

[priyarane]

Not working

[MK_QSL]

What is the dimension(s) you have in this chart/table?

[priyarane]

%YearMonthID - dim, %CurrentYearMonthID - selection