Select Customers with open orders from customers table

AppSheet AppSheet Q&A
1

Hi

I have a standard parent child order system.

I have a slice of an orders table that gives the customers with open orders below

COUNT(SELECT(Orders[Order Id],AND([_THISROW].[Outlet No]=[Outlet No],[Order Status]=“Open”)))>0

I’m trying to find the yes/no expression for a slice of the customers table to show the customers with an open order rather than a slice of the orders table.

thanks

Phil

2

Create VC like

If
IF(
COUNT(SELECT(Orders[Order Id],AND([_THISROW].[Outlet No]=[Outlet No],[Order Status]=“Open”)))>0,
true,
false
)

And use this VC to slice it out?

1 Like
3

Try something like:

ISNOTBLANK(
  FILTER(
    "Orders",
    AND(
      ("Open" = [Order Status]),
      ([_THISROW].[Customer Id] = [Customer Id])
    )
  )
)
3 Likes