Level 1 modal building exam medical costs

Zhiying
Occasional Contributor

Level 1 modal building exam medical costs

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

2 REPLIES 2
bhatjaved
Regular Contributor

@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
Occasional Contributor

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