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
Solved! Go to Solution.
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
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
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.
Thank you - so obvious when you explain.