Set Analysis Help

[etrotter]

Here is my formula:

  Sum({<[Activity Freeze Month Year Index] =Max({<[Month Year]=,Year = {'$(=Max({<[Month Year]=>}

  [Activity Freeze Year])-2)'}>}[Activity Freeze Month Year Index])>}[PL Counter])

If I just put :

=Max({<[Month Year]=,Year = {'$(=Max({<[Month Year]=>}   [Activity Freeze Year])-2)'}>}[Activity Freeze Month Year Index])

in a text box it works and returns a 12, but it's not working inside the formula. Please let me know if you have any ideas!

Thanks,

Erica

[YoussefBelloum]

Hi,

your set analysis syntax is incorrect:

you should write it like this:

aggregation_function(    {<  FIELD={ }  >}    FIELD)

[sunny_talwar · Accepted solution]

Try this

Sum({<[Activity Freeze Month Year Index] = {"$(=Max({<[Month Year], Year = {'$(=Max({<[Month Year]>} [Activity Freeze Year]) - 2)'}>} [Activity Freeze Month Year Index]))"}>} [PL Counter])