Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
You are mixing IF condition with Set Expression syntax..
Try :
if( [LW_FLAG] = 1 , [Long Wait], Null() )
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.
Thankyou for your help