Forum Discussion
Filter expression by another column
Hello, The following sales table exists: [Entry DateTime], [Customer], [Item Sales Qty.], [Sales Amount]. Task: For a specified period (e.g. 11/15/20 - 12/25/20, column [Entry DateTime]), t...
Hello Greg_Deckler,
I tried to describe the task more in detail.
I understood that the price per unit would be needed.
That's why I added a column with the price per unit to the data sample.
But most probably this task will be hard to implement.
But still.
An addition to the task description.
As far the function meets the conditions, it ignores the next lines.
For example, with the client ABC01524
The function, at this customer should take into account the sum of 2 items for 02.12.2020 and the sum of 2 items for 03.12.2020, the sum of the other 6 items for 03.12.2020 the function should ignore, as well as the next sale for 11.12.2020.