set analysis with 2 different data types

[kmswetha]

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?

[sunny_talwar]

This is in alternate state

KeepChar(Only({[state1]}F2), '0123456789') * Only({[state1]}F3) & PurgeChar(Only({[state1]}F2), '0123456789')