Larger or equal to YearMonth in set analysis

[hiringel]

Hey,

This formula works great for getting the RWA value from 6 months back:

Sum(

{<YearMonth={"$(=date(AddMonths(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),-6),'YYYYMM'))"}>}

RWA)

How do I make it fill a chart with all values 6 months back, in other words, what is the syntax for  ">=", the "larger than or equal to" set analysis?

[Anil_Babu_Samineni]

May be this?

Sum({<YearMonth={">=$(=date(AddMonths(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),-6),'YYYYMM')) <=$(=date(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),'YYYYMM'))"}>} RWA)

OR

Sum({<YearMonth={">=$(=date(AddMonths(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),-6),'YYYYMM')) <=$(=date(Max(YearMonth),'YYYYMM'))"}>} RWA)

[hiringel]

No, it just shows "No data to display"

[Anil_Babu_Samineni]

Could be format issue, Can you attach sample

[hiringel]

Here is a test file that has an example of the challenge

[hiringel]

Sure, put one as a response to the original question. Thanks!

[antoniotiman]

May be this

Sum(

{<YearMonth={">=$(=date(AddMonths(Max({<RWA={[=(Len(RWA)>=0)]}>}YearMonth),-6),'YYYYMM'))"}>}

RWA)

[hiringel]

No, I am afraid not, it just shows "No data to display"

I attached a test file above if that helps!

[antoniotiman]

Sum(
{<YearMonth={">=$(=Num(date(AddMonths(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),-12),'YYYYMM')))"}>}
RWA)

[hiringel]

Hey, that works for RWA! Great!
Do you know how to make it work for the CostOfCredit example as well?