Level 1 Model Building Exam-Model Building Activity 6

neg177

Hi,

 

I want to see if I'm on the correct track for writing the formulas needed for Module REP04 Employee Expense Summary. 

 

IF Employed? THEN Salary [LOOKUP: 'SYS08 Employee Details'.Role LOOKUP: "SYS08 Employee Details'.Region] ELSE 0

 

Please let me know if heading in the correct direction.

 

Thank you 

andre.lie

Hi @neg177

 

You are building formula for a target line item in REP04 module.  However, your formula tells that your source line item 'Salary' is also in the same REP04 module because there is no module reference in front of Salary.  If source and target line items are in the same module, you generally do not need to use a LOOKUP. 

 

You might need to think whether your source line item is actually in another module.  In that case, you can use either LOOKUP or SUM function to bring the number to REP04 module