Running Total & Cubes

Hello,

I’m looking to breakdown a customer order into pallets which are under 45 cubic ft. I attempted a two method to get pallets under 45 cubic feet but kept coming up with pallets over 45 cubic feet.

The closest I’ve gotten is with the follow method (Method B in the attached workflow) is

  1. Calculate the running total up to 45 cubic feet

  2. Assign a Pallet ID

  3. Group by Pallet ID to confirm the pallet is under 45 cubic feet

Does anyone know how I can update the workflow to always build a pallet under 45 cubic feet?

Calculate PLT Cube.knwf