Forum Discussion
Error in Switch Statement
Hi,
I m getting error "Too many arguments were passed to VALUES function".
Actual = SWITCH ( TRUE (),
VALUES(Matrix[ID]) in { 1,2,3,4} , [Operational SUM],
VALUES(Matrix[ID]) in { 5,6,7,8} , [Non Operational SUM],
BLANK()
)
I need to find [Operational SUM] and [Non Operational SUM] based upon multiple ids.Any help on this
Thanks
Anonymous , if column try like
Actual = SWITCH ( TRUE (),
Matrix[ID] in { 1,2,3,4} , [Operational SUM],
Matrix[ID] in { 5,6,7,8} , [Non Operational SUM],
BLANK()
)
if measure try like
Actual = SWITCH ( TRUE (),
max(Matrix[ID]) in { 1,2,3,4} , [Operational SUM],
max(Matrix[ID]) in { 5,6,7,8} , [Non Operational SUM],
BLANK()
)
2 Replies
Anonymous , if column try like
Actual = SWITCH ( TRUE (),
Matrix[ID] in { 1,2,3,4} , [Operational SUM],
Matrix[ID] in { 5,6,7,8} , [Non Operational SUM],
BLANK()
)
if measure try like
Actual = SWITCH ( TRUE (),
max(Matrix[ID]) in { 1,2,3,4} , [Operational SUM],
max(Matrix[ID]) in { 5,6,7,8} , [Non Operational SUM],
BLANK()
)