11.3.4: Headcount and Expenses not matching

JeffFischer
JeffFischer
edited November 2022 in
 

Hi! Can someone please help me, I am not sure where I went wrong. For Level 1, 11.3.4 my Headcount is off by 1 and my expenses are all off because of this. Thank you in advance for your help!

JeffFischer_0-1668803327188.png

 

JeffFischer_1-1668803327249.png

 

 

Comments

  • Karthik31
    Karthik31
    edited November 2022

    Hi, 

    Check the formula in blue print view if it matches the below one: 

     

    IF 'SYS09 Version Details'.Forecast? THEN 'EMP02 Employee Expenses'.Headcount[SUM: 'SYS08 Employee Details'.Country] ELSE 'DATA01 P&L Actual and Budget'.Headcount

     

     

    Hope this helps!!

    Happy Learning. 

  • JeffFischer
    JeffFischer
    edited November 2022

    Hi @Karthik31, thank you! My formula does match the below. Does this mean that something is probably wrong in my data and I need to re-upload the data?

  • Karthik31
    Karthik31
    edited November 2022

    Hi @JeffFischer 

     

    Yes I believe because mapping the data might also effect a few times 

    Please do check on that and summary as well 

     

    attached below is the screenshot for reference of summary in blue print view 

    Screenshot (74).png

  • Timbollew
    Timbollew

    Old post I know, but I have exactly the same numbers as what you were getting @JeffFischer I'm scratching my head and cannot resolve, can you remember what the issue was?

Categories