Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys Yesterday I was helped put an If statement in the script, if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team','Yes','No') as [Corp Ops Backvaluation] It works a charm !!! But today I need to amend it a little, I need to add in another and where [Type of Event] is not "Margin Change" I have tried the following but getting an Error in expression: ')' expectedon load if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team' and [Type of Event] not 'Margin Change' ,'Yes','No') Pleeeeaaasseee Help Thanks Anne
hi,
change
not 'Margin Change' "
to
<> 'Margin Change'
that should do the trick.
*** DONT KNOW WHAT HAPPENED FORMAT ABOVE ***
Hi Guys
Yesterday I was helped put an If statement in the script,
if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team','Yes','No') as [Corp Ops Backvaluation]
It works a charm !!!
But today I need to amend it a little, I need to add in another and where [Type of Event] is not "Margin Change" I have tried the following but getting an Error in expression: ')' expectedon load
if( [Was backvaluation required ?] ='Yes' and [Issue held with] = 'Cops Team' and [Type of Event] not 'Margin Change' ,'Yes','No')
Pleeeeaaasseee Help
Thanks Anne
hi,
change
not 'Margin Change' "
to
<> 'Margin Change'
that should do the trick.
Thanks Pat , just realised that!
All working good now
Thanks