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

ShawnaM
ShawnaM
in Modeling

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! 

Screen Shot 2022-04-11 at 8.51.52 AM.png

 

. 

 

 

Tagged:

Comments

  • anand.shekhawat
    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

Categories