How can I do a running total in a search? Currently I have this formula which gives me the running total, but it is backwards, meaning the first entry is the largest running total 😕

sum/* comment */({quantity}) OVER(PARTITION BY {item} ORDER BY {item}, {expectedreceiptdate} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

The ORDER BY seems off to me, not sure why there an

{item}

in there

because it needs to be in order for it to have a running total