lookup and error message

RavinderB
RavinderB
in Modeling

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

 

 

Tagged:

Answers

  • ChrisAHeathcote
    ChrisAHeathcote

    @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 

     

  • Ingilavicus
    Ingilavicus

    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
    ashish.banka

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

     

    Hope this helps.

    AB

Categories