Help with If statement

[hopkinsc]

Hi all, i can't think properly today!

i am trying to create a new field in the script with the following conditions.

I have 6 fields (3 new and 3 old as below)

BusinessUnit

BusinessUnit_OLD

Department

Department_OLD

Division

Division_OLD

I want to create a flag field 'RoleChange_Flag' if the above do not match each other , i.e. if BusinessUnit <> BusinessUnit_OLD then 1 as RoleChange_Flag.

but i want RoleChange_Flag to be populated if either of them are different, so something like..

if(BusinessUnit<>BusinessUnit_OLD,1 or if(Department<>Department_OLD,1 or if(Division<>Division_OLD,1))) as RoleChange_Flag

I can't seem to get the syntax right.

any help would be appreciated

[m_woolf · Accepted solution]

if(BusinessUnit<>BusinessUnit_OLD or Department<>Department_OLD or Division<>Division_OLD,1) as RoleChange_Flag

[MK_QSL]

If(BusinessUnit <> BusinessUnit_OLD or Department <> Department_OLD or Division <> Division_OLD,1) as RoleChange_Flag

[hopkinsc]

ahh, i was certain i needed to use multiple if statements!

Thankyou!