EMP03 Employee Drivers by Role does not return any data

Options
Hali
Hali Member, ALL USERS, Partner Posts: 5 Contributor
in Planning & Modeling

Hi

 

Not able to retrieve data for Bonus, Medical costs etc.. though all the formulas are correct.  Screen shot attached

Tagged:

Comments

  • Hali
    Hali Member, ALL USERS, Partner Posts: 5 Contributor

    Even though i changed the qualification .. Then also it did not work.

     

     

  • Hali
    Hali Member, ALL USERS, Partner Posts: 5 Contributor

    Here is the screenshot of both EMP02 and EMP03

    Thanks

    Hameed

  • Hali
    Hali Member, ALL USERS, Partner Posts: 5 Contributor

    I have the same formula that you had specified for all rows.. In the 2nd screenshot that i had sent, the formulas are same as that you had mentioned....

     

    Please check.. I had sent you on the screenshot the correct formulas referring to role...

  • Hali
    Hali Member, ALL USERS, Partner Posts: 5 Contributor

    I checked the top level item for both department and Roles..  It all looks fine to me.

    The top items has been defined as All Departments and All Roles respectively for Department and Roles.   

     

    The Parent Hierarchy is blank for both the entities.  Pasting here the screen shots of SYS08 and the Hierarchy details of Department and Roles pls.

     

     

  • Bernadett
    Bernadett Member, ALL USERS Posts: 5 New Contributor

    Hi!

     

    I changed Role to List format, but after entering the formula, I still don't get any values back just 0s.
    "

    'EMP03 Employee Drivers by Role'.Car Allowance[LOOKUP: 'SYS08 Employee Details'.Department, LOOKUP: 'SYS08 Employee Details'.Role]

    "

    Bernadett_0-1650054276480.png

     

    Could you please help me, why?

    Bernadett_1-1650054347859.png

     

     

  • Bernadett
    Bernadett Member, ALL USERS Posts: 5 New Contributor

    Thanks!

    But in between I got the roles correctly.

    Bernadett_0-1650059634537.png

     

    But the sums still incorrect:

    The SUM is way higher, how it should be:

    Bernadett_1-1650059710133.png

     

     

    And if I drill down, I see that it is because 

    The formula counts everybody in not just the employees with the selected role.

     

    Even though, The Roles are already correctly attributed according to SYS08.

     

  • Bernadett
    Bernadett Member, ALL USERS Posts: 5 New Contributor

    And I can select an employee and a role, (which is she not actually) and I still get results below, even though i shouldn't.

    Bernadett_0-1650060763585.png

     

  • Bernadett
    Bernadett Member, ALL USERS Posts: 5 New Contributor

    Bernadett_0-1650061174559.png

     

    The problem is, that even if i set the role, then the selection doesn't reflect to the data, as Shala is not an executive..

     

  • Bernadett
    Bernadett Member, ALL USERS Posts: 5 New Contributor

    Even though, it is imported correctly: 

    Bernadett_0-1650061341637.png

     

  • Leonolgun
    Leonolgun Member, ALL USERS, Partner Posts: 3 New Contributor

    Hi,

     

    I have the same problem. Only returning zeros... did anyone solve the problem? I cannot find it anywhere.

Categories