SUM & LOOKUP
Hi All,
Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item
If I use SUM & LOOKUP both at the same time for the same line item, its giving me correct details as expected
However, if, don't want to use SUM & LOOKUP at the same time, then what can be the options -
- I tried with subsidiary views & it worked as well
- If I want to break this equation into SUM & LOOKUP separately, its not working. I tried creating an intermediary module with same dimension, however its still showing as error
Any idea where have I gone wrong
Thanks
BB
Best Answer
-
In another module, dimensionalized by Region, do your cost sum. Then, if you need the totals for that region, you can do lookups using a list formatted line item (Region).
Rob
2
Answers
-
I think you should create separate modules for the SUM and LOOKUP calculations. In one module, use the LOOKUP function to retrieve the necessary data, and in another module, use the SUM function to perform the desired calculations. Ensure that the dimensions and relationships between modules are set up correctly for accurate results.
0