So it looks like I needed MAX() around (CASE WHEN (TRUNC({today}) - {trandate}) < 30 THEN {quantity} ELSE 0 END). Does that make sense, I know it made the formula work, but does that make logical sense?