Compute Method

Computes an aggregation expression on the rows that satisfy a filter condition.

Syntax

Visual Basic
C#

'Declaration
 
Public Function Compute( _
   ByVal expression As System.String, _
   ByVal type As System.Type, _
   ByVal filter As System.String _
) As System.Object

public System.object Compute( 
   System.string expression,
   System.Type type,
   System.string filter
)

Parameters

expression
type
filter

Remarks

This function computes aggregation expressions only. For example, you can use it to compute a sum of a field over rows, as in Sum(Quantity) (correct), but not to compute an expression depending on multiple fields in a single row, as in UnitPrice * Quantity (incorrect). For computations involving multiple fields in a single row use field C1.Data.SchemaObjects.Field.Calculations.

Reference

C1DataTable Class
C1DataTable Members