cancel
Showing results for 
Search instead for 
Did you mean: 

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

MoyaMar2
Explorer
0 Kudos

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
Participant
0 Kudos

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
Explorer
0 Kudos
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.

Accepted Solutions (0)

Answers (1)

Answers (1)

MoyaMar2
Explorer

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
Participant
0 Kudos
I don't quite get the logic, but may I know if the column applying the formula is non-String type?
MoyaMar2
Explorer
0 Kudos
The column type is String.