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.