lookup and error message

RavinderB
Contributor

lookup and error message

Hi 

 

Please advise on what this error means : lookup error - please see image attached - thank you

 

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

 

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

 

please see attached error

 

role is in a list and formatted as a text field

 

thank you

 

 

3 REPLIES 3
ChrisHeathcote
Community Boss

Re: lookup and error message

@RavinderB 

LOOKUPS require a time period or List formatted line item NOT Text.

Update the line item in the mapping and convert it to a list format.

Use FINDITEM to do this. 

Chris 

 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA
Ingilavicus
Certified Master Anaplanner

Re: lookup and error message

Hi @RavinderB ,

 

Lookup can only use a List or Date formatted item. So the error is saying that in your lookup you are using something other than the to. And as you say that role is text the LOOKUP formula does not acept it. 

You have to turn the role LI into a list and use it as the line item format to use it for lookup. 

 

Andris

ashish.banka
Super Contributor

Re: lookup and error message

@RavinderB Agree with both @Ingilavicus and @ChrisHeathcote . Just change the format of "Role" Line item from TEXT to Role List. That would help resolve the Lookup error.

 

Hope this helps.

AB