Level 1 Anaplan Model Training Data Mismatch

christinaperez
New Contributor

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

2 REPLIES 2
anand.shekhawat
Super Contributor

Re: Level 1 Anaplan Model Training Data Mismatch

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

ChrisHeathcote
Community Boss

Re: Level 1 Anaplan Model Training Data Mismatch

@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.  

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA