Level 1 Anaplan Model Training Data Mismatch

 

Here are the formulas that I'm using, but every time I input them in EMP02 I get this error: Data type mismatch: format other than LIST or DATE being referenced as a relation

 

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

Car costs - IF Employed? THEN 'EMP03 Employee Drivers By Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Phone costs - IF Employed? THEN 'EMP03 Employee Drivers By Role'.Phone Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Medical costs -  IF Employed? THEN 'EMP03 Employee Drivers By Role'.Medical Benefit[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role] ELSE 0

Tagged:

Answers

  • Hi @christinaperez ,

     

    The formulas seems correct. Kindly check your SYS08 Module.

    The Department and the Role line items in SYS08 Module should be list formatted and populated correctly by using formula/import. Also make sure the dimensions used in both the modules is correct.

     

    I hope it helps.

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • @christinaperez 

    LOOKUP only works when the line item used in the mapping is LIST formatted. 

    Look through the system module used in the LOOKUP to ensure that they are all list formatted.