Custom list of products

[chandran]

Good day

I want to create a custom list of Products with sales. The items with no sales must also be reflected on the sheet. I have the set analysis expression below, but only the items with sales reflect. I need to see a zero against those items that have no sales.

How do I amend this expression?:

Sum({$<[Product Code]={'1023','2014','1029','MKD-02','SM190'},Year={$(vMaxYear)}>}Quantity)

Please assist.

Kind regards

Chandran

[tresesco]

@chandran Try like:

Sum({$<[Product Code]={'1023','2014','1029','MKD-02','SM190', "=Sum(Quantity)=0"},Year={$(vMaxYear)}>}Quantity)

[chandran]

Hi Tresesco,

I am getting items that are not on the list. See below. I only need to see the items as per the set analysis.

[tresesco]

The items with no sales must also be reflected..

---

@chandran  you are seeing these extra products because that have zero sales and I thought that that was your requirement. Could you explain a bit more may be with an example?

[chandran]

@tresesco My custom list of products are eg.1,2,3,4,5. I want only these items to show on my sheet ( no other items).

The sheet should look something like this:

Product Code                   Qty Sold

1                                                   10

2                                                   20

3                                                    0

4                                                   50

5                                                      0

Hope this makes sense of my requirements.

Kind regards

Chandran

[tresesco]

@chandran , that means some items with zero values are getting suppressed. So you just need to enable zero inclusion, like:

[chandran]

@tresesco I have that ticked

[tresesco]

@chandran Could you share your sample app?

[chandran]

@tresesco  Unfortunately I cannot for security reasons. Could you perhaps do some testing on your app?

[tresesco]

@chandran 

I can. However,  I suspect that the issue would be with your app or the way you are trying to get that. So an app from my end would not help.😐