Set Analysis - Previous YTD excluding Month selections

[#1]

Hi Guys,

Below is my set analysis expression to calculate Previous Year Total.

Sum({$<[FinYear]={$(=max([FinYear])-1)}>} GLTranAmount)

Within my model, I'd like to exclude all selections based on Month.

This will ensure that a the Previous Year Total will only change when a different year is selected, i.e. it is a static total by year and not a rolling Previous Year YTD.

I've looked at Set Identifiers to exclude Month selection(s) but to no avail.

Does anyone have a solution?

Thanks in advance.

[#2 · Accepted solution]

Hi,

Try using the below formulae.

Sum({$<[FinYear]={$(=max([FinYear])-1)},Month = >} GLTranAmount).

- Sridhar

[#3]

Thanks, works a treat.

I had the correct syntax but was placing it before the {$<[FinYear={$(.... condition.