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?