Help on SetAnalysis

[#1]

HI All,

I Want to get an Outstanding Amt (Sum(Amt)).I have data which starts from 200901.

So now for Eg: :when i click 201002 (Feb'2010) i should get sum of outstanding from 2009-01 to 201002.

I am using the below code its not working

=num(sum({$<Year = {$(=max(Year))}, Month = {"<=$(=max({<Year={$(=max(Year))}>} Month))"}>} Amt), '#,##0;($#,##0)')

CAn Any one please help me.

Thanks in Advance

Regards,

Ankit

[#2]

Hi,

I think that the problem in your formula is int month part, You can try like this:

NUM(SUM({$<Year = {$(=max(Year))}, Month = {"<=$(=max(Month))"}>} Amt), '#,##0;($#,##0)')

Tell us later if it works

Regards

Orlando

[#3]

No this is not working...

Please any one can help on this.....

[#4]

No this is not working...

Please any one can help on this.....

[Miguel_Angel_Baeyens]

Hi,

You may have a Date field, that will change depending on the selection for Year and Month field. So basically, you need in your set analysis all those records which date started one year ago. The idea then would be

=num(sum({$< Date = {">=$(=AddYears(DateField, -1))"} >} Amt), '#,##0;($#,##0)')

Hope this helps!