Compensation Lookup Table: How to make all unmapped combinations blank instead of N/A.

[MoyaMar2]

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 tweak this formula? Or is there a value I need to add to the lookup table to display blank when value not found. 

Formula: if(customGPA>0.00,lookup('2023_Grant_WarningFlag',customBD,customGPA,1), ' ') 

Edit: 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)), ' ')

[CarsonWongIVC]

Wonder if setting wildcard record in lookup as catch-all scenario will help your case.

Ref: https://help.sap.com/docs/SAP_SUCCESSFACTORS_COMPENSATION/d2457f2b6a8f4429b46314ee814fc666/3d0a19498...

[MoyaMar2]

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.

[MoyaMar2]

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)), ' ')

[CarsonWongIVC]

I don't quite get the logic, but may I know if the column applying the formula is non-String type?

[MoyaMar2]

The column type is String.