Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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}>}value)+sum({[state1]<field1={2}>}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.
Any suggestions?
This is in alternate state
KeepChar(Only({[state1]}F2), '0123456789') * Only({[state1]}F3) & PurgeChar(Only({[state1]}F2), '0123456789')