Level 1 11.3.4 - Formula Error

[lcapon]

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

[Kanishq17]

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]

[rob_marshall]

@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]

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]

@lcapon 

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

[lcapon]

[rob_marshall · Accepted solution]

@lcapon 

Remove Users from the Applies To

[lcapon]

Thank you - so obvious when you explain.