Level 1 lesson 10.2.6

vyshnavsk

after inputting the formulas they get this,

but i get a blank for the line items starting from bonus to medical costs and TEE is computed wrong for me without adding the rest as shown below,

below i have uploaded the blueprint version also,

rob_marshall

@vyshnavsk

Did you reload the data in SYS08 Employee Details after you changed the format for Country?

rob_marshall

@vyshnavsk

What are the formats of Department and Country in Employee Details?

vyshnavsk

@rob_marshall for department it makes me choose E1 departments lists since its not allowing other formats and for country its text.

rob_marshall

@vyshnavsk

Look at Country, the format is TEXT and should be list formatted. You can only do lookups on list formatted line items and Time.

vyshnavsk

@rob_marshall

okay, but having changed the country format to list, it still shows the same,

vyshnavsk

@rob_marshall

yes, thanks a ton it worked

rob_marshall

@vyshnavsk

When you ask a question, please remember to mark the response as Answered…Also, I would caution you against marking responses as Rejected Answer as you did above as that is the true answer (a lookup can't be performed on a Text formatted line item).

Rob

vyshnavsk

Oh I am sorry, i unknowingly must have marked that.