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.