SUM & LOOKUP

CommunityMember111277
CommunityMember111277
in Modeling

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

Tagged:

Best Answer

  • rob_marshall
    rob_marshall
    Answer ✓

    @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

Categories