Level 1 Model Building Exam Model Building Activity 6

TCHRIS55
Contributor

Level 1 Model Building Exam Model Building Activity 6

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

2 REPLIES 2
Akhtar.shahbaz
Community Boss

Re: Level 1 Model Building Exam Model Building Activity 6

Hi @TCHRIS55 ,

 

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

ChrisAHeathcote
Community Boss

Re: Level 1 Model Building Exam Model Building Activity 6

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

Chris
HeathcoteAndHerran.com