Data type mismatch: format other than LIST or DATE being referenced as a relation Error

ShawnaM

Hello,

 

I'm trying to this formula for the bonus line item and I'm getting an error message.

 

IF Employed? THEN Salary * 'EMP03 Employee Drivers by Role'.Bonus %[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

 

Can I have some help on what is wrong? Thank you! 

 

. 

 

 

anand.shekhawat

Hi @ShawnaM 

 

Kindly check the format of the 'Department' and 'Country' line item in the SYS08 Employee Details Module. Both should be List formatted as you are using a LOOKUP upon them.

 

~Anand