Multiple Alternate states in set analysis

[#1]

Hi,

Could someone help me in understanding what is wrong with the below expression. I have to use two alternate states for this expression hence alt1 and alt3.

=if (GetSelectedCount([Com Service Group])<>0 and GetFieldSelections([ComPeriod]) ='YTD', sum({alt1*alt3<FY_SH20 = {'2017'},Entity_SH20 = {'APAC'},Period_SH20 = {'YTD'}, Month_SH20 = {'Nov'}>}  Hours_SH20))

Thanks!

Arun

[sunny_talwar]

Looks fine to me, what is the issue that you are seeing?

[#3]

The expression is not working for for the second alternate state.

[sunny_talwar]

Unless you elaborate on what is not working, I don't think we will be able offer much help. Try to provide a sample or provide more details