...
For example: %%=Products.[Sales Person] or %%=[Dat@ $ource].ColumnName
Modifiers
Modifiers can effect how data is imported into the template file. Modifiers use the following syntax: %%=DataSourceName.ColumnName(modifier)
...
For more help getting started with PowerPointWriter see our HelloWorld and Basic tutorials.
Merge Field Formulas
Anchor | ||||
---|---|---|---|---|
|
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 field. Formulas are evaluated for all values of the field in the data source, regardless of how many of the values are actually displayed in the document.
PowerPointWriter supports the following data marker formulas:
AVERAGE | Calculates the average of the field values |
---|---|
COUNT | Returns the number of values (that is, the number of rows in the data source) of the field |
COUNTA | Returns the number of non-null values of the field |
MAX | Returns the maximum value from the field |
MIN | Returns the minimum value from the field |
PRODUCT | Calculates the product of the field values |
STDEV | Returns the standard deviation of the field values, treating the values as a sample |
STDEVP | Returns the standard deviation of the field values, treating the values as a population |
SUM | Calculates the sum of the field values |
VAR | Returns the variance of the field values, treating the values as a sample |
VARP | Returns the variance of the field values, treating the values as a population |