| Compliance | Approvalindicator | Approval date |
| | | |
| N/A | Yes | |
| N/A | Yes | |
| N/A | NO | 01-01-2019 |
| N/A | NO | |
| N/A | NO | |
IF(Compliance='N/A' AND ApprovalIndicator='true','Approved N/A',
iF(Compliance='N/A'AND ApprovalIndicator='false','Not Approved N/A',
Compliance))) as CalculatedCompliance,
In the above table, I have coded the above syntax and works fine, I also have to add one more if in the same loop for the below condition, not able to get the syntax.
iF(Compliance='N/A' AND ApprovalIndicator='false', and [here i have to check if anything is entered in this cell it can be date or any string in Approvaldate field ) 'Approved N/A',
Can anyone help me with syntax, please?? ie
if Compliance =N/A and
ApprovalID=NO and
if any value is present in the Approval date column then it should return 'Approved N/A' (this could be number or string in the cell)
