Level 1 11.3.4 - Formula Error

lcapon
Contributor

Level 1 11.3.4 - Formula Error

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

9 REPLIES 9
Kanishq17
Community Boss

Re: Level 1 11.3.4 - Formula Error

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
Contributor

Re: Level 1 11.3.4 - Formula Error

lcapon_0-1614096992000.png

 

 

lcapon
Contributor

Re: Level 1 11.3.4 - Formula Error

lcapon_0-1614097559139.png

 

rob_marshall
Moderator

Re: Level 1 11.3.4 - Formula Error

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

Re: Level 1 11.3.4 - Formula Error

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
Moderator

Re: Level 1 11.3.4 - Formula Error

@lcapon 

 

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

lcapon
Contributor

Re: Level 1 11.3.4 - Formula Error

lcapon_0-1614100270248.png

 

rob_marshall
Moderator

Re: Level 1 11.3.4 - Formula Error

@lcapon 

 

Remove Users from the Applies To

lcapon
Contributor

Re: Level 1 11.3.4 - Formula Error

Thank you - so obvious when you explain.