Level 1 Model Building Exam Model Building Activity 6

TCHRIS55
TCHRIS55
in Modeling

I need a little help figuring out why I’m getting the the message pictured when entering my formulas. 

Tagged:

Answers

  • Akhtar.shahbaz
    Akhtar.shahbaz

    Hi @TCHRIS55 ,

     

    Your source format of the line item is different from Target, Please check the format of the line item

  • ChrisAHeathcote
    ChrisAHeathcote

    @TCHRIS55 

    I suspect the format of the line item used in as the LOOKUP reference is text formatted. 

    LOOKUP only works when the reference is LIST or TIME PERIOD formatted. 

    Change the format of the reference used in the function to the relevant list ( I also suspect it should be the Role list ) and the LOOKUP should work. 

Categories