topic Re: Set expression - exclusion issue in App Development

Set expression - exclusion issue

Emil_bros — Fri, 08 Jul 2022 12:44:19 GMT

Hi,

I have a table with sales by customer and calendar day.

I need a set expression that, after I select specific date range, will display only "new customers" in selected date - in other words customers that generated sales in selected date range but not generate sales in not selected dates.

eg. when selecting date 08.07.2022 only customer A should be displayed because customers B ad C already had sales in the past.

I think I need to use EXCLUSION operator here but not sure how entire expression should look.

Emil

Re: Set expression - exclusion issue

rubenmarin — Sat, 09 Jul 2022 10:19:10 GMT

Hi, it could be something like:

Sum({<Customer=E({<Date={"<$(=Min(Date))"}>} Customer)>} Sales)

Re: Set expression - exclusion issue

Emil_bros — Mon, 11 Jul 2022 08:33:56 GMT

thank you, almost correct. Finally I have used following (based on your answer):

sum( {$<Customer = E({1<Date={"<$(=Min(Date))"}>})>}Sales )