SUM & LOOKUP

[CommunityMember111277]

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

[rob_marshall · Accepted solution]

@CommunityMember111277

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