topic Set Analysis Help in App Development

Set Analysis Help

etrotter — Thu, 15 Feb 2018 15:40:05 GMT

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

Re: Set Analysis Help

YoussefBelloum — Thu, 15 Feb 2018 15:45:18 GMT

Hi,

your set analysis syntax is incorrect:

you should write it like this:

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

Re: Set Analysis Help

sunny_talwar — Thu, 15 Feb 2018 15:48:38 GMT

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