can we sum multiple record's field value in flow designer !!!

[chandan15]

In time card(time_card) table, one user can have multiple time card for a week. I want them to sum up the value, (like 2 record of a user for a week, monday of first record and second record will summ), and will populate into new record(time card rollup table).

Can anyone please help me on this......

[Sam Goode]

Coud you set a flow variable to 0 before the loop

Then for each item in Time Card Records:

Get time card record value and add it to the flow variable

After the loop, the flow variable should be the sum of all values

[chandan15]

yeah,  tried this, but it is picking only one record, however there is 5 records per user, per week.

[Sam Goode]

I think the step in that image "Create Fieldglass Time Card Rollup Record" should be moved outside of the loop.

You want it to loop through all the records and update the variable, then once it has done all of that you can update the time card rollup record with the total value from the variable right? At the moment it looks like it's creating a rollup record for each time card record.