Description

Operations are commutative if the order of operands can change without changing the result. So the same block is used to do the following operations:

  • Sum
  • Average
  • Product
  • First
  • Last
  • Min
  • Max
  • Or
  • And
  • Count

These operations are all applied on columns to compute a result and columns order doesn't matter.


The operations will happen a new column to the previous tables, so all the columns will remain available and an additional column will appear.


Implementation


Properties

  • ColumnName: The name of the new column containing the result. 
  • Columns: The columns to compute on. SFormat should be used, basically column() or columns() functions.
  • Operator: The operator to use. 


Summary