Hi, I have a problem with a formula.
In my table I have a column called people involved in the deal. The output for the cells in this column must be the count unique of people . The formula is as follows. The problem is that I can’t relate the delivery date range to the values present in the people involved on deal.
Let me explain with an example: if I select a range as the delivery date of the last seven days I will certainly have some people involved. With the formula that I have, now, in the column of people involved is shown all the people involved for all the tasks of that deal. without filtering it by the delivery date. How can I modify the formula so that it finds the selected range on the delivery date?
This is the formula:
[Import - Deals]
.Filter(
[Deal name] = thisRow.[Deal name]
)
.[Task associati]
.Filter(
[Data consegna] >= min([Select Data consegna]) AND [Data consegna] <= Max([Select Data consegna])
)
.Operativo.CountUnique()