I have a form with 2 subtotals. Each subtotal should sum an amount based on criteria:
Total Cost 1
Sum (cost) where class in ("equipment", "Carts", "other")
Total Cost 2
Sum (cost) where class = "service" + Sum(adjustment)
How would you set this up on a form?