Calculate Summary

This action will calculate a summary of column values of selected items, located in any list of any site collection. You can use the calculated value to update a column of the current item or raise an error when the calculated value does not pass a predefined condition. For example, you can prevent reserving a conference room when there is already a reservation for the same time slot. 

1. Site – select a site from the current site collection. Use runtime value to specify site URL only known at run time.
2. List – select a list from the selected site. Use runtime value to specify list title only known at run time.
3. Items – enter at least one filter value for selecting target list items for applying the action. To select a single item use the ID column.
4. Result – either save the value in the current item or evaluate condition to raise an error.
5. Column – select a column in the source list to get the values from
6. Operator - when Result is set to Update column, performs summary of values
7. Column to update – when the result is set to Update, select a column from the current item to update
8. Condition - appears when Result is set to Raise error. When the summary does not pass the condition, error is raised.
   1. Operation name – operation to perform on the values. You can count, sum, calculate an average; get the maximum and the minimum values. When Result is set to Raise error, you can also specify All to test each item for a positive result or Any to test any item for a positive result.
   2. Operator - depending on the value type of the column, you can use such operands as Equals, Contains, Greater than, Less than and so on.
   3. Comparison value - value to compare the calculation result to
9. Error – enter error message to be shown when the value does not pass the condition. When setting your action to run synchronously, you can prevent the item from being created/saved if it raises an error.