How can I check, in the member formula, does Employee has this property in the smart list?

Apr 22, 2026 9:44PM · Apr 22, 2026 9:44PM

Summary:

I'm trying to create a logic in the OWP_Custom Expense by using the member formula.

I have to calculate benefits for employees who have specific value in the Smart List.

Account name is Citizenships, data type the smart list (name is Citizenship)

Content (please ensure you mask any confidential information):

It should look like this :

IF ("No Property"->"BegBalance"->"ON Province"->"OWP_Benefit1" == [OWP_BenefitList.CPP1] AND "Citizenship" == 4)
"OWP_Benefit1" = (("OWP_Expense Amount"->"OWP_Total Salary") + ("OWP_Expense Amount"->"OWP_Total Earnings")) * (("OWP_Value"->"OWP_Benefit1") / 100);

 ELSE "OWP_Benefit1" = #Missing;

ENDIF;

The first part of the condition is working fine, but when I added the AND operator with the second condition, it stopped working. And if I add this condition as a nest it's not working too.

How can I check, in the member formula, does Employee has this property in the smart list?

Howdy, Stranger!