Hi,Since the 2H 2023 release went in for testing, we noticed an issue when we try to edit some fields under "Edit Employee History" directly in the UI.Steps --- Navigate to your VarPay Template > Plan Setup > Manage Users > Edit Employee History. Sea...
I'm testing a new lookup table. If my combination of keys (2) is NOT found on the table, I would like the value/output to be blank instead of "N/A". I tried wrapping the table in a custom formula but still unable to get the desired result. How can I...
After much trial and error, this is the formula if anyone is curious: if(customGPA>0.00, if(lookup('2023_Grant_WarningFlag',customBD,customGPA,1)='N/A', ' ', lookup('2023_Grant_WarningFlag',customBD,customGPA,1)), ' ')
Thanks Carson! I also tried adding this wildcard/default value line item to the lookup table, but the output still shows N/A instead of blank. Or displays whatever text I put in that box.
