Lost sales

[#1]

Hi all,

I would like to know how do I not have the sales in the period?
I already have the sales made now would like to know which products were not sold in that period?
Thanks,
Gleybson Fernandes

[Miguel_Angel_Baeyens]

Hello,

Assuming that those who haven't sales for the period are all but those who do have sales, using set analysis the expression to return the count may look like

Count({1 - < ID = {"=Sum({< Date = {'>=$(=Date(PeriodStart))<=$(=Date(PeriodEnd))'} >} Sales) > 0"} >} ID)

Meaning all IDs except for those that have Sales in the period greater than zero. Above syntax may require some cleanup.

Hope this helps.

[spividori]

Hi MIguel.

I have a similar query, I need to select a client to display all products that do not buy, unspecified period.

The fields of my table are: Customer, Product and Quantity.

Regards.

Sandro.

[#4]

Miguel, thank you for the post but did not resolve.
have any other suggestions?