New Contributor

## 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

2 REPLIES 2
Community Boss

## Re: SUM Question...

@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

New Contributor

## Re: SUM Question...

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