SUM Question...

I need a hand on this, should be something easy, hopefully someone can help me. 

I have a LIST of 62 items (Products) 
These products has their transactional data in another LIST.
I have a Module A with 4 categories of these items. 
2 Categories are coming as they are in the Product List, the other 2 are determined based on the transactional data. Each category has their own items to be classified C1=4 items, C2=3, C3=4, C4=4 items. 
In this Module A there is a FLAG with a "1" in the formula so I can able to count the products.

I created a Module B and I want to count the amount of Products of the Category 3.
To do that I am using the SUM function
'Module A'.Count Flag Product[SUM: 'Module A'.Category 3
I got results per category but too high!, looks like is doing the SUM per every category.

I've always have a total SUM for Category 3 of 11,904. 
Doing the math is 62 items x (4 x 3 x 4 x 4) = 11904. 

Probably more information is required to understand better, I am wondering if this has to be something with the way  data has been imported and the unique values but not sure about that. 

Any idea?
Thanks, 
Francisco
















Answers

  • @fpalomino

     

    What is the dimensionality of Module B or target line item?

     

    For the sum to work correctly it needs to be dimensioned by Category 3 (for your example)

     

    Can provide more details, screenshots of the modules (source and target)?

     

    David

  • David, 
    I solved this few weeks after I posted, I didnt see your post until now. 
    I was able to solve it, seems like very dimension in the module was causing that SUM calculates as expected. 

    Thanks for your support. 
    Francisco