...
The PowerPointTemplate object evaluates a number of different formulas placed in data markers using the format %%=FORMULA_NAME(DataSource.ColumnName). Each of the formulas will perform a specific operation on the values of the referenced data fieldcolumn. Formulas are evaluated for all values of the field column in the data source, regardless of how many of the values are actually displayed in the document.
...
AVERAGE | Calculates the average of the field column values |
---|---|
COUNT | Returns the number of values (that is, the number of rows in the data source) of the field column |
COUNTA | Returns the number of non-null values of the field column |
MAX | Returns the maximum value from the field column |
MIN | Returns the minimum value from the field column |
PRODUCT | Calculates the product of the field column values |
STDEV | Returns the standard deviation of the field column values, treating the values as a sample |
STDEVP | Returns the standard deviation of the field column values, treating the values as a population |
SUM | Calculates the sum of the field column values |
VAR | Returns the variance of the field column values, treating the values as a sample |
VARP | Returns the variance of the field column values, treating the values as a population |