LEVEL 1 EXAM MODEL BUILDER ACTIVITY 5

DavidGmora
DavidGmora
in Modeling

Hello everybody.

 

i´ve been stuck in this activity since yesterday, a create a Role list, With a top level of all roles, then i import the new data in the SY08 EMPLOYEE DETAILS with the extra role line and i don´t get any issue with the data.

 

The thing is that when i try to change my formula for the BONUS, CAR COSTS, PHONE COSTS AND MEDICAL COSTS, i get the numbers, but a still get my answers wrong,

 

i put the aplies  to : ROLE, E2 Employees#: Active?

 

and my formulas for each are these:

BONUS:

CAR COSTS:

 

PHONE COSTS: 

 

MEDICAL COSTS:

If anyone can tell me a little hint maybe i can fixed something in my formula. Thank you.

Tagged:

Answers

  • rob_marshall
    rob_marshall

    @DavidGmora 

     

    Just wanted to let you know I edited your post because we don't want the answers posted to the community as we want people to learn, instead of looking up the answers.  With that said, you can definitely ask the questions, just please don't post your formulas for "exam" questions.

     

    With that said, take another look at your Applies To and ask yourself why you need "both" of those lists.

     

    Rob

Categories