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

kebe
kebe
in Academy Discussions

this is the formula 

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

Tagged:

Comments

  • rishabh01
    rishabh01

    Hey @kebe 

    Make sure that item you are referencing in your lookup is list formatted. Currently, it is text formatted I believe.

    Thanks, 

    Rishabh.

  • kebe
    kebe

    you are right, i formatted the role as text while it was a list

  • rishabh01
    rishabh01
    Great! You can accept the solution if it worked.

Categories