Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using two alternate states (Left and Right) to compare two periods. In my expression I want to derive the number of new customers where the previous period is in alternate state Left. The latest period is in alternate state Right. I try to ignore a selection on [Department] in the deault state.
However the outcome of the calculation differs when I make a selection on Department in the default state.
What is wrong with my expression?
Count({Right*$<
%Relation_key = e({Left*$}%Relation_key),
[Department]=
>}
DISTINCT %Polis_key)
I don't use alternate states very often, but what state is your selector using for Department?
Hi Mark,
The selector for Department is using the default state.