Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Looks fine to me, what is the issue that you are seeing?
The expression is not working for for the second alternate state.
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