Separation of data

[Ehumphree]

Hi, trying to separate data between long wait and in time data set.

 =if({<[LW_FLAG]={1}>}Long Wait) 

=if({<[LW_FLAG]={2}>}In Time)

I know I am doing something wrong. Any help is much appreciated.

[PradeepK]

You are mixing IF condition with Set Expression syntax..

Try :

 if( [LW_FLAG] = 1 , [Long Wait], Null() ) 

[MayilVahanan · Accepted solution]

Hi @Ehumphree 

Try like below

 =if([LW_FLAG]=1, 'Long Wait') 

=if([LW_FLAG]=2, 'In Time')

If you want nested if condition, try like below

if([LW_FLAG]=1, 'Long Wait', if([LW_FLAG]=2, 'In Time'))..

If Long Wait & In Time are field, remove the single quotes.

[Ehumphree]

Thankyou for your help