2 Replies Latest reply: Oct 6, 2017 5:59 AM by Mark van der Meij

# Applying an alternate state in set analysis : Problem

I'm having some trouble with a formula that combines set analysis and alternate states.

I'm using a container box, which is set to an alternate state.

The regular formula needs to show the #FTE valid for the current month/year.

sum({<Year={\$(=Max(Year))}, [Calender.MonthNr]={\$(=Max([Calender.MonthNr]))},  [KPI Code]={'FTE'}>}[KPI Actuals])

Now; the problem is that I have a generic month & year in the report and I want the formula, which is part of of the alternate state, to respond to the proper max month selected.

Normally you can override the alternate state with Year= \$::Year

I do not know how to properly apply this is the current situation though.

sum({<Year={\$(=Max(Year##INDEFAULTSTATE##))}, [Calender.MonthNr]={\$(=Max([Calender.MonthNr##INDEFAULTSTATE##]))},  [KPI Code]={'FTE'}>}[KPI Actuals])

Anyone know how to properly get this chart to work from the container that is in an alternate state?

• ###### Re: Applying an alternate state in set analysis : Problem

May be this?

sum({<Year={\$(=Max( {\$} Year))}, [Calender.MonthNr]={\$(=Max({\$}[Calender.MonthNr]))},  [KPI Code]={'FTE'}>}[KPI Actuals])

• ###### Re: Applying an alternate state in set analysis : Problem

This is correct ! Thanks you!