I'm having a set analysis with alternate sates where I have show data of 2 different data types, Both number and string
Here is what i'm using, MaxString({[state1]<field1={1}>}ir02.kpi_value)+sum({[state1]<field1={2}>}ir02.kpi_value) since data is of 2 different data types set analysis is not performing OR operation.
Other way i'm trying is using if condition but not sure how to use alternate states in if condtion.