I have built an app for a food business, they take orders and they want a simple list of all the orders for which the status of the order is complete in an invoice. The problem is I an able rollup the amount based on the Status - Completed but not able to exclude Pending status create a total. Please help.
Use a Query column with appropriate filters to match the orders that you want, then do a rollup through the query column.
3 Likes