如何使用另一个列表中的数据创建计算列 [英] How to create calculated column with data from another list
问题描述
我有以下情况:列表 A 有两列(名称、金额),在列表 B(名称)中我想添加一个计算列,该列应该是列表 A 中所有同名条目的总和在列表 B 中.示例:
I have the following situation: List A has two columns (Name, Amount) and in List B (Name) I want to add a calculated column which should be the sum of all entries in List A that have the same name as in List B. Example:
列表 A:
NAME Amount
L0011 100
L0011 50
L0020 234
所以在列表 B 中我希望计算列显示:
So in List B I want the calculated column to show:
NAME Amount
L0011 150
L0020 234
这是怎么做到的?工作流程(只要我在列表 A 中添加/修改一个条目,更新列表 B)或其他什么?谢谢
How can this be done? Workflow (as soon as I add/mod an entry in List A, update List B) or something else? Thanks
推荐答案
使用计算列无法做到这一点,因为计算列只能用于同一列表中的列.
This can't be done using calculated columns because calculated columns can only be used for columns on the same list.
使用 SharePoint Designer 工作流,您只需使用 Create List Item
和 Update List Item
操作,这样每当用户添加 L0011 的值时,该金额就会添加到另一个已包含先前金额的列表列.
Using SharePoint Designer Workflows you can just use Create List Item
and Update List Item
actions so that whenever a user adds a value for L0011 the amount will be added in another list's column which contains the previous amounts already.
如果您需要有关 SharePoint 方法的更详细的答案,请告诉我,我会为您提供有关如何操作的分步说明.
Let me know if you need a more detailed answer for the SharePoint approach and I'll provide you a step by step instruction on what to do.
这篇关于如何使用另一个列表中的数据创建计算列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!