SUM & LOOKUP

CommunityMember111277
Contributor

SUM & LOOKUP

Hi All,

 

Just wanted to clear some doubts on usage of SUM & LOOKUP at the same time for same line item

ex.JPG

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
rob_marshall
Moderator

Re: SUM & LOOKUP

@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

View solution in original post

1 REPLY 1
rob_marshall
Moderator

Re: SUM & LOOKUP

@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

View solution in original post