Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
Try using the below formulae.
Sum({$<[FinYear]={$(=max([FinYear])-1)},Month = >} GLTranAmount).
- Sridhar
Hi,
Try using the below formulae.
Sum({$<[FinYear]={$(=max([FinYear])-1)},Month = >} GLTranAmount).
- Sridhar
Thanks, works a treat.
I had the correct syntax but was placing it before the {$<[FinYear={$(.... condition.