This function performs math operations to the current page, or selected columns.
Syntax:
MathOperation, operation, value, param2, axis, aggregation
Parameters:
operation – the math function to be used { Divide, Multiply, Subtract, Add, FillEmptyWithLag, FillEmptyWithValue, FillWithValue, Cumulative, StdDev }
value – the numeric value to be used with the operation
param2 – unused { 0 }
axis – which axis will be used for the cumulative operations { Row, Column } (other functions are for selected columns only)
aggregation – identifies the operation that will be used, in this case, the actual value supplied { Actual, CumulSum, CumulAverage, CumulMaximum, CumulMinimum }
Examples:
MathOperation,Divide,33,0,Row,Actual
Divide the actual values in each cell by 33
MathOperation,FillEmptyWithLag,-1,0,Row,Actual
Fills empty cells with the value in the column to the left.
MathOperation,Cumulative,0,0,Row,CumulSum
Converts numbers into a cumulative sum running across the rows to the right.
MathOperation,Cumulative,0,0,Column,CumulMaximum
Converts numbers into a cumulative maximum down the columns.
Comments:
FillEmptyWithLag fills all empty cells with the number to the left or right (relative by value columns) of the empty cell. Note that axis is ignored.
FillEmptyWithValue fills all empty cells with value.
FillWithValue fills all cells in the selected row or column with value.
StdDev wills all cells with the number of standard deviations away from the axis average.
Aggregations CumulSum/CumulAverage/CumulMaximum/CumulMinimum can only be used with the Cumulative operation.
The math operations operate on selected columsn only – not selected rows.
|
