Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
status close_flag
closed -1
>closed -1
closed-opp -1
open 0
completed 0
if(close_flag= -1,if( (match('closed','>closed', 'closed-opp' ),'closed', status),status
in the expression if close_flag equal to -1 then combined the all closed values( into closed filed other wise it display the remaining values. the expression plz correct or not other wise plz tell me and write correct expression urgent......plz any one
the expression is not working plz tell me ....
May be like:
......(match(status, 'closed','>closed',
Hi,
Like this
if(close_flag= -1,if( wildmatch(status,'closed','>closed', 'closed-opp' ),'closed', status))
Regards