SUM function usage on different dimensionality
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.