4 Replies Latest reply: Sep 3, 2010 8:30 AM by Miguel Angel Baeyens de Arce

# Help on SetAnalysis

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)')

Regards,

Ankit

• ###### Help on SetAnalysis

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

• ###### Help on SetAnalysis

No this is not working...

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

• ###### Help on SetAnalysis

No this is not working...

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

• ###### Help on SetAnalysis

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!