Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to understand how a calculated dimension fits into an expression.
If I label the calculated dimension, why cant I use this in the set analysis part of the expression?
And what is the work around?
My calculated dimension
Label 'ABC Status'
=IF(len([Action])=1,IF(([Created Date]+[Days])>[Load Date],'On Track','Overdue'),'Placed')
My Set expression
=count(DISTINCT {$<[ABC Status]={'Overdue'}> + <[ABC]={'On Track'}>} [Action])
Only fields can be used in set modifiers on the left side of the =. Expressions, expression labels and labels of calculated dimensions cannot be used.
As [ABC Status] = 'On Track' or [ABC Status] = 'Overdue' should define the same set as Len(Action)=1 one solution might be:
=Count(DISTINCT {$<Action={"=Len(Action)=1"}>} Action)
hope this helps
regards
Marco