Level 1 Module Building Exam - Model Building Activity 5

Options
HaddoxCommunityAccount
HaddoxCommunityAccount Member, ALL USERS Posts: 4 New Contributor
in Planning & Modeling

Help, I get all zeros for my results after building the formula in EMP02 Employee Expenses. When I set the Role to list, The text disappeared in my SYS08 Employee Details. I am two hours into this without a solution. Here are some screen shots:

SYS08 missing data in Role column

HaddoxCommunityAccount_0-1620413989874.png

Role line item as a list "Role"

HaddoxCommunityAccount_1-1620414019024.png

 

Formula example I am using

HaddoxCommunityAccount_2-1620414069099.png

EMP02 showing zeros.

HaddoxCommunityAccount_3-1620414093595.png

I can only get text in SYS08 if I set the Roles line item to text but then the formula won't work!

 

Help!!

 

Tagged:

Comments

  • CaitlinHester
    CaitlinHester Member, ALL USERS Posts: 1 New Contributor

    Hi,

     

    I am trying to write the same formulas and am getting the below error message.  Were you able to solve for this error message?  I feel like I've missed something in the set up of E3 Roles but I keep going back and looking and don't see anything wrong.  TIA.

     

    CaitlinHester_0-1620416435767.png

     

  • HaddoxCommunityAccount
    HaddoxCommunityAccount Member, ALL USERS Posts: 4 New Contributor

    No solution yet. Something in the mapping or formatting must be off when I imported to the list or the module. I think the import of SYS08 Employee details didn't marry up some how. It's not the best way but you could manually add the roles to SYS08.

Categories