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
1,337

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

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.