Set Analysis Expression

[Anonymous]

I have the following expression:

I get the following error message:

What could be wrong with the expression?

[sunny_talwar · Accepted solution]

I think you have extra parenthesis in your set analysis

Try this:

=Num(Sum({<MonthID = {"<=$(=Max(MonthID))"}>}, Year = {$(=Max(Year))}, Quarter =, Month= >} Amount))

[jduenyas]

Yap. That is correct. Extra paren.

[Anonymous]

Thanks Sunny

I get the following error message with your suggestion:

[Anonymous]

Hi Sunny

Removing the extra circled symbols works.

[sunny_talwar]

This time I added an extra parenthesis. I fixed it in the above expression also:

=Num(Sum({<MonthID = {"<=$(=Max(MonthID))"}>}, Year = {$(=Max(Year))}, Quarter =, Month= >} Amount))