Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try this
Sum(
{<YearMonth={">=$(=Num(date(AddMonths(Max({<CostOfCredit={">0"}>}YearMonth),-12),'YYYYMM')))"}>}
CostOfCredit)
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)
No, it just shows "No data to display"
Could be format issue, Can you attach sample
Here is a test file that has an example of the challenge
Sure, put one as a response to the original question. Thanks!
May be this
Sum(
{<YearMonth={">=$(=date(AddMonths(Max({<RWA={[=(Len(RWA)>=0)]}>}YearMonth),-6),'YYYYMM'))"}>}
RWA)
No, I am afraid not, it just shows "No data to display"
I attached a test file above if that helps!
Sum(
{<YearMonth={">=$(=Num(date(AddMonths(Max({<RWA={"=(Len(RWA)>=0)"}>}YearMonth),-12),'YYYYMM')))"}>}
RWA)
Hey, that works for RWA! Great!
Do you know how to make it work for the CostOfCredit example as well?