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

Welcome!

It looks like you're new here. Sign in or register to get started.
Sign In