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?
Please post a screenshot of the whole template.
Template
Grand Total Row Outputting for each sale rather than once for all sales
<<START:Payments[Log ID]>>
is telling the system to create a row in the template for each row in the Payments table. It looks like if you just removed that second Start expression (and the End), then itโll do what you want.
Also, you can replace
<<TEXT( Grand Total)>>
With just:
Grand Total
Iโd advise reviewing the Start expressions help articles another time.
Thatโs what it was. Thanks so much!!!
User | Count |
---|---|
44 | |
29 | |
22 | |
20 | |
14 |