From a table extract rows with a condition but tha...

Jmgr · 08-12-2021 10:10 AM

From a task table, I try to extract the rows of clients that do have finished tasks but do not have new tasks started. It is about not leaving customers abandoned by mistake.
It seems simple, but it does not come out
How could it be done
Thanks

Marc_Dillon

It is very hard to help you without more detail, but here is a generic expression you might start from:

AND(
  ISNOTBLANK( FILTER( Tasks , #are-finished-condition# ) ) ,
  ISBLANK( FILTER( Tasks , #are-started-condition# ) )
)

You’ll probably want to use this in a Slice.

From a table extract rows with a condition but that other data from the table is not repeated