Level 1 11.3.4 - Formula Error

Options
lcapon
lcapon
in Modeling

Hi - I have tried to look through the response of those who have had a similar error but I'm afraid I'm still not too sure how to fix this. 

 

Error:

 

Invalid formula for 'REP03 Profit & Loss Report'.Revenue: Automatic sum of 'EMP02 Employee Expenses'.Headcount over Users hierarchy is not possible as Users does not have a built-in top level

Tagged:

Best Answer

Answers

  • Kanishq17
    Kanishq17
    Options

    Hi @lcapon 

     

    Can you share screenshots for the same , check dimensionality between source and target modules , in your case , you need to set a mapping for users dimension in target module using list formatted line item and then use lookup

     

     

  • lcapon
    lcapon
    Options

    lcapon_0-1614096992000.png

     

     

  • lcapon
    lcapon
    Options

    lcapon_0-1614097559139.png

     

  • rob_marshall
    rob_marshall
    Options

    @lcapon 

     

    Not sure why are you using Users in the source module, but since it does not have a Top Level member, you will not be able to sum the data from that module.

     

    Rob

  • lcapon
    lcapon
    Options

    Are users not correct then? What should I be using? Can you tell where I may have made a mistake? I'm assuming I havent followed the lesson correctly. 

  • rob_marshall
    rob_marshall
    Options

    @lcapon 

     

    Can you show us the blueprint of your source module, EMP02 Employee Expenses?

  • lcapon
    lcapon
    Options

    lcapon_0-1614100270248.png

     

  • lcapon
    lcapon
    Options

    Thank you - so obvious when you explain.

Categories