10 Replies Latest reply on Dec 22, 2016 1:30 AM by erolst

    IsEmpty not working?


      Hi, I am trying to check for a field compliance, basically if the targeted field is empty, the compliance field will return "Non-Compliant" and if it's not empty (any text/number in edit box or certain option under in a value list), it will return "Compliant". I've tried setting the compliance field into a calculation field as such, If ( IsEmpty(Table::TargetedField) ; "Non-Compliant" ; "Compliant" ). However, the compliance field returns with "Non-Compliant" even if the field is not empty. Appreciate if anyone could help, thanks!!