Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Hi, there
try this
IF(Compliiance='N/A' AND Approvalindicator='Yes','Approved N/A',
IF(Compliiance='N/A'AND Approvalindicator='No' and (Not isnull("Approval Date")),'Approved N/A',
iF(Compliiance='N/A'AND Approvalindicator='No','Not Approved N/A',Compliiance)
)
) as calc
ZZ
Hi there
You can add Len(Trim([Approval date])). Len looks at how many characters there is in the field and trim removes all the spaces. It will return 0 if the cell is completely empty or only has spaces and a number greater than 0 if there is anything at all. So your condition will be Len(Trim([Approval date]))>0 in your if statement. For example:
iF(Compliance='N/A' AND ApprovalIndicator='false' AND Len(Trim([Approval date]))>0, <True result>,<False result>)
Good luck,
Mauritz
Hi, there
try this
IF(Compliiance='N/A' AND Approvalindicator='Yes','Approved N/A',
IF(Compliiance='N/A'AND Approvalindicator='No' and (Not isnull("Approval Date")),'Approved N/A',
iF(Compliiance='N/A'AND Approvalindicator='No','Not Approved N/A',Compliiance)
)
) as calc
ZZ