Workflow Template Totals Row

[Jordan_Davis1]

I have a workflow template that provides a list of all sales for the last month. I want the last row to be a totals row for all columns so I made a separate start expression

<<Start:Table[Key ID]>><<TEXT(Grand Total)>>

Then each cell has a SUM(Select, however, it’s returning a separate row for each sale, instead of one row for all. The expression I’m using is

<<SUM(SELECT(Payments[Amount],[Client] = “Client”))>>

Any ideas what I’m doing wrong?