Description: Calculates a custom value after the built-in statistics of a normal result cell have been calculated.
Execution: The formula runs once for each normal statistics result cell that uses CustomStatistic.
Arguments:
Argument_NMin: average of the N lowest values; NULL if no value is available.
Argument_NMax: average of the N highest values; NULL if no value is available.
Argument_Min, Argument_Max, Argument_Sum, Argument_Average: the corresponding built-in results.
Argument_StandardDev: sample standard deviation using an N-1 denominator; NULL for at most one value.
Argument_Median, Argument_Q1, Argument_Q3: median and lower/upper quartiles.
Argument_Count: number of processed values.
Result: Required. Result becomes the raw and displayed value of the custom statistics cell and is formatted by the configured reference entry or statistics item.
Availability: Statistics item formula. Grouped aggregate rows, columns and super results currently display *** instead of recalculating CustomStatistic.
Example:
if Argument_Count > 0 then
Result := Argument_Average
else
Result := NULL;