Returns the percentage of records fulfilling the condition of the average.
PercentOfAverage( fld, condFld ) PercentOfAverage( fld, condFld, cond )
fld | The name of a field or array variable whose values should be used to calculate the percentage value. |
---|---|
condFld | The name of the field that groups the values of fld (if fld isn't an array). |
cond | A string declaring the type of grouping to be used on condFld. This only makes sense for groups based on Date, DateTime, Time, and Boolean fields. See Summary Field Conditions for a list of strings you can use here. |
A number.
PercentOfAverage({Product.Unit_Price}, {Product.Category}) // returns the percentage part of the average unit price of a given product category.