sort ignores "{col}": a running total is a function of the sort order, so it cannot also decide it. Sort by the column it runs over instead.

Warnings reference › source.sort.running.*

Identifier

source.sort.running.*

Raised by

The grid (core)

Since

1.9.1

What happened

A running total is computed along the current order, so sorting by it would define the order in terms of itself - a question with no fixed point. The entry is dropped, the way an unknown column is, and the rest of the sort applies.

The fix

Sort by the column the running total runs over, or by its orderBy column.

Reference

Covered in full at the API reference.