Action
PercentOfAverage (fld, condFld) has the same effect as: 100 * Average (fld, condFld) / Average (fld). It expresses the average of the values of the field fld for the group determined by condFld as a percentage of the average of all the values of fld.
PercentOfAverage (fld, condFld, cond) has the same effect as: 100 * Average (fld, condFld, cond) / Average (fld). The String argument cond expresses some additional information to precisely specify the grouping. For example, if condFld is a Date field, is the grouping "daily" or "weekly" or "monthly" and so on.
PercentOfAverage (fld, innerCondFld, outerCondFld) has the same effect as: 100 * Average (fld, innerCondFld) / Average (fld, outerCondFld). It expresses the average of the values of the field fld for the group determined by innerCondFld as a percentage of the average for the group determined by outerCondFld.
PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld) has the same effect as: 100 * Average (fld, innerCondFld, innerCond) / Average (fld, outerCondFld).
PercentOfAverage (fld, innerCondFld, outerCondFld, outerCond) has the same effect as: 100 * Average (fld, innerCondFld) / Average (fld, outerCondFld, outerCond).
PercentOfAverage (fld, innerCondFld, innerCond, outerCondFld, outerCond) has the same effect as: 100 * Average (fld, innerCondFld, innerCond) / Average (fld, outerCondFld, outerCond)