Attribute Assistant : Populate a field value based on the value of 2 fields

237
0
05-07-2019 01:13 PM
AhmadSALEH1
Occasional Contributor III

Attribute Assistant - Populate a field value based on the value of 2 fields

Hello,

I am using Attribute Assistant to populate a field based on the values of 2 fields, but I am not sure how to do that.

for example, this is how my data looks: 

OPS_Status Data_Status Status
 Yes    Yes   Complete
No Yes   Waiting OPS
 Yes   NoWaiting Data

in the Attribute Assistant I used the following expression:

IIF([OPS_Status]="Yes" AND [Data_Status]="Yes","Complete") 

This should fill "Complete" for the first row, but for some reason its not working! 

Any help is highly appreciated,

Ahmad

0 Kudos
0 Replies