Answered

How to calculate total of a SharePoint column?

(1) Share

Report

Posted on by cooper33

249

Feel like this should be way easier than I'm making it but I can't get this to work. I want to calculate a running total of the values in a column called Hours in a SharePoint list. This column may or may not be empty. Here is what my flow is doing

1. Initialize variable (runningTotal, Float type)

2. Get items from SharePoint list

3. Apply to each value (from Get items)

4. Increment variable runningTotal, Value = Hours (from Dynamic content)

Issue is that the runningTotal is the evaulating to the total number of the items in the list. When I walk through the loop, it increments by 1 for each item in the SP list from Get items

I tried adding a Condition to attempt to only add when the Hours field is not null, but I don't think I'm doing that right with the new Flow upates. I tried Hours is greater than 0, which failed on the items where Hours was null. I tried Hours is not equal to '' which still counted everything.

Any suggestions?

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

ScottShearer 25,280 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@cooper33 :

Please post a screen shot of your Flow - that will make it much easier to assist.

Here is an example of now you might approach your issue.

I have a list with a number column call Available Quantity.

The Flow below loops through the list and adds the Available Quantity in each row to the variable.

When the Flow is complete, the variable holds the total of all values in the Available Quantity column.

If this addresses your issue, please mark you post as Solved.

Scott

Was this reply helpful? Yes No
Verified answer

cooper33 249 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the response. The configuration in your screenshot is what I had and was trying to describe. It was only incrementing by 1 and not taking into the account of the field in the loop.
I had to add a Condition to the loop to check if the field was not equal to null. If Yes, I incremented the value as shown in your screenshot.

Was this reply helpful? Yes No
leyburn19 2,157 on at

Like (0)

Report
Copy link

Link copied!

Can you supply a screenshot. No matter what I do I still only get increment by one

Was this reply helpful? Yes No