Level 1 modal building exam medical costs

Zhiying
Zhiying
in Modeling

Hi,

 

I’m attempting the question to update the formula for pulling allowances from SYS08 module. However I got the error “data type mismatch. Format other than LIST or DATE being referenced as a relation”

 

may I know what does that mean?

 

the formula I have keyed is:

IF Employed? THEN Salary * EMP03 Employee Drivers by Role’.Bonus Percentage [Lookup: SYS08 Employee Details’.Department, Lookup: SYS08 Employee Details’.Role] ELSE 0

Tagged:

Comments

  • bhatjaved
    bhatjaved

    @Zhiying 

     

    Can you share the screen shot of SYS08 module , you need to use Employees role and department as look up reference - your formula looks correct though ,just ensure your sys08 module is correct.

  • Zhiying
    Zhiying

    Hi, 

     

    I have figured out. I would need to change the format of roles to list. previously i was not able to do so as i did not remove the modules that were linked to it. after deleting the linked modules, i was able to format the roles of list

Categories