SUM function usage on different dimensionality

Options
VarshniR
VarshniR Member, ALL USERS, Community Member Posts: 5 New Contributor
in Planning & Modeling

Hi,

Please let me know if anyone can help me on the below question.

 

I was trying to analyze an existing module. Here is an simple example of the logic I was trying to analyze.

I have 2 modules namely Module 1 and Module 2. Module 1 has a line item 'Total' and Module 2 has two line items BU and Hours. 

The formula for 'Total' is Module2.Hours [SUM:Module2.BU].

Note- The BU is list formatted which contains its list items in text format and Hours is a number formatted.

 

Please can anyone help me on the logic here.

However, i tried reproducing this formula in similar other modules, it threw me an error that it is of different dimensionality.

 

Please can anyone let me know the logic the above formula holds in case of different dimensionality.

 

Regards,

Varshni

Tagged:

Comments

  • VarshniR
    VarshniR Member, ALL USERS, Community Member Posts: 5 New Contributor
    Thanks Niranth.
    Yes, even I'm of the same idea that we need to use LOOKUP but unfortunately this model was not built by me. I'm just analyzing the existing or implemented system.
    It would be great if you could help know the existing logic works.
    Thanks,
    Varshni
  • VarshniR
    VarshniR Member, ALL USERS, Community Member Posts: 5 New Contributor

    Hi,

     

    PFB the screenshots of the issue. I have blurred up the data for security reasons. Request you to please through the formula and let me know the logic.The BU line item is list formatted.

     

    Capture.PNG

  • VarshniR
    VarshniR Member, ALL USERS, Community Member Posts: 5 New Contributor
    Thank you Arun.
    Its not about the error. My question is I just want to know what the formula in module 1 holds or I just want to understand the logic or the meaning or analysis of the below formula
    'Capacity - Analysis (Input/Output) - Actual'.'Total Expected Working Hrs.'[SUM: 'Capacity - Analysis (Input/Output) - Actual'.BU]
  • VarshniR
    VarshniR Member, ALL USERS, Community Member Posts: 5 New Contributor
    Thanks a lot Chris.

Categories