SF Compensation Lookup Field returning 0

[Pooja2]

Hello Compensation Consultants,

I have created a custom formula to fetch values from lookup table with 4 keys and 1 output:

toNumber(lookup('AA_LOOKUP1',ServiceArea,payGrade,YALBefCap,custPM,1))

All keys are correctly populated in the form so it should fetch the corresponding amount from the table but for all employees, the formula returns 0. The lookup table doesn't have any entry for 0 amount and I checked multiple times if keys are correctly coming and they are.

Can somebody please help?

[xavierlegarrec]

Hi compconsultant

Try the following formulas :

1. lookup('AA_LOOKUP1',ServiceArea,payGrade,YALBefCap,custPM,1)
2. lookup('AA_LOOKUP1',ServiceArea,toNumber(payGrade).YALBefCap,custPM,1)

If none of them works, please send screenshots of the following :

• every single column used as attribute as seen from the worksheet and from design worksheet
• the design worksheet view of the column in which you are inserting the lookup table
• the lookup table itself

All the best,

Xavier