使用HTTP服务对列进行求和 [英] Using HTTP Service to sum a column

问题描述

嗨 

我有一个创建Http Web服务工作流，它扫描一个列表，循环返回2列。

Empires（员工姓名）

daystaken（Days）

当前工作流程的结果如下。 是否有可能得出一个总结每位员工天数的流程（注意当前结果中可能有多行）

解决方案

< blockquote>

您好，

我不确定HTTP服务是否能实现您的目的（至少我认为此要求与HTTP服务相比非常麻烦），但我有一个更简单的方法来满足您的要求。 

您可以编辑列表视图并使用"分组依据"对行进行分组（和求和）。转到列表设置>修改视图>向下滚动到"分组依据"并选择"员工姓名"作为价值。然后根据需要对列进行求和。

参见下面的示例：

对行进行分组后：

您还可以参考以下文章了解有关您的要求的其他解决方案：

https：// stackoverflow .com / questions / 27420387 / sum-data-in-a-column-based-another-column-report-builder-sharepoint

< a href ="https://social.msdn.microsoft.com/Forums/office/en-US/1c2b7801-e528-49be-82f5-f9b0a0f5b637/how-to-sum-all-items-from-one-column-在一览一个与 - 条件 - 和 - 然后保存求和值到列表-b？论坛= sharepointdevelopmentprevious"> https://social.msdn.microsoft.com/Forums/office/en-US / 1c2b7801-e528-49be-82f5-f9b0a0f5b637 /如何到总和 - 所有项目 - 从 - 一个共lumn-in-list-a-with-conditions-then-save-save-sum-value-to-list-b？forum = sharepointdevelopmentprevious

祝你好运，

Allen Bai

Hi 

I have a create Http web service workflow that scans through a list and with a loop returns 2 columns.

Empires (Employee name)
daystaken (Days)

The results from the current workflow are below.  Is it possible to get a process that sums up the days per employee (note there may be more than one row as shown in the current results)



解决方案

Hi,

I am not sure if  HTTP Service would achieve your purpose(At least I think this requirement is very troublesome to do with HTTP Service), but I have a easier method for your requirement. 

You can edit your list view and use "Group By" to group (and sum) your rows. Go to List Settings > Modify View > scroll down to 'Group By' and select ''Employee name" as the value. Then Sum the column as you need.

See below example:

After group your row:

You can also refer to below articles for other solutions about your requirement:

https://stackoverflow.com/questions/27420387/sum-data-in-a-column-based-on-another-column-report-builder-sharepoint

https://social.msdn.microsoft.com/Forums/office/en-US/1c2b7801-e528-49be-82f5-f9b0a0f5b637/how-to-sum-all-items-from-one-column-in-list-a-with-conditions-and-then-save-sum-value-to-list-b?forum=sharepointdevelopmentprevious

Best regards,

Allen Bai

这篇关于使用HTTP服务对列进行求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！