The formula will stop evaluating a value when it finds a match as true.
So if A=1, it will return 'X' and the next 'elseif' will never be evaluated.
Effectively, you cannot calculate A='1' as being both X and Y in the same dimension.
You can create three calculated fields to judge X,Y,Z instead.
if [A]=1 or [A]=2 then "X" END
if [A]=1 or [A]=3 then "Y" END
if [A]=2 or [A]=4 then "Z" END
XYZ_9.2.twbx 14.6 KB