Add rows into a table and then sum up values

Like (0) Share

Report

Posted on 26 Jan 2024 11:51:07 by BenWadeZ

Hi everyone, I have a flow that adds rows into excel file. I want the flow to sum up values after adding rows to show total amount and count at the end
How to do this?

I have the same question (0)

All responses (2)

Answers (1)

Bartelli 75 on 26 Jan 2024 at 15:19:53

Like (0)

Report

Re: Add rows into a table and then sum up values

I would add two steps: 1-get rows from the table you just created using "list rows present in a table" 2-add a row into a table and add an expression to add a sum and a count to amount and receipts, respectively. You'll need to make sure you have a table created.

Let me know if this helps. Thanks!

Was this reply helpful? Yes No
Verified answer

BenWadeZ 19 on 26 Jan 2024 at 20:44:15

Like (0)

Report

Re: Add rows into a table and then sum up values

I just manually added in excel file =sum([Amount]) and =count([Amount]) and it worked like a charm.

Was this reply helpful? Yes No