Level 1 Model Building Exam REP04 Employee Expense Summary

Katjaj
Katjaj
in Academy Discussions

Hi,

I'm a little bit confused with REP04 report. I have built up report and in some rows numbers are exactly the same as in Exam (Executive, Senior Director), but some rows differ, for example row Director. Can anyone help?

image.png
image.png

Answers

  • Rakesh2909
    Rakesh2909

    Hi @katjaj,

    Please check your Dimensions properly. G1 Region list, Role List , Time in years.

    image.png

    And update the formulas based on Region and Role which you have created in system module.

    image.png

    After updating you should get the same results which Anaplan has Provided.

  • Katjaj
    Katjaj

    Hi,

    thanks, dimensions should be correct in the report:

    image.png

    I also checked that departments & roles are correct per person. What bothers me is that Salaries differ from exams table, should I copy salary data again to Anaplan?

Categories