Example:
Round("Sales")
StartsWith(TextExpression1, TextExpression2]
Boolean that returns true if the first text input starts with the string specified in the second input; false otherwise.
Examples:
StartsWith("Product Name", 'Q')
StdevP (NumericExpression[,'Level])
Standard deviation based on the entire population, taken over the values at the specified (optional) level. Null values are excluded. Level can be one of the following: Current (default), ColumnGroup, ColumnTotal, RowGroup, RowTotal, Total. See Levels in Aggregate Functions for more information.
Examples:
StdevP("Sales",'RowTotal')
StdevS (NumericExpression[,'Level])
Standard deviation based on a sample, taken over the values at the specified level. Null values are excluded. Level can be one of the following: Current (default), ColumnGroup, ColumnTotal, RowGroup, RowTotal, Total. See Levels in Aggregate Functions for more information.
Example:
StdevS("Sales",'RowTotal')
Sum (NumericExpression[,'Level])
The sum of all values in the range. Null values are excluded. Level can be one of the following: Current (default), ColumnGroup, ColumnTotal, RowGroup, RowTotal, Total. See Levels in Aggregate Functions for more information.
Examples:
Sum("Sales",'RowGroup')
Today (Integer)
Calculates the date that is the specified number of days from the current system date.
Examples:
Today (0) — The current system date.
Today(1) — The day after the current system date.
Today(-1) — The day before the current system date.
WeightedAverage (NumericExpression1,NumericExpression2,'Level')
Returns the weighted average for the first input weighted with respect to the second input, calculated at an optional level. Null values are excluded. Level can be one of the following: Current (default), ColumnGroup, ColumnTotal, RowGroup, RowTotal, Total. See Levels in Aggregate Functions for more information.
Examples:
WeightedAverage ("Price","Units", 'Current') — The extended price based on the number of units.
WeightedAverage ("Price","Units", 'RowGroup') — The sum of the extended price for all units in the row group.
Year (DateExpression)
Given a date field, returns the year.
Examples:
Year("Order Date" )
Recommended Comments
There are no comments to display.