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 | No | Waiting 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
