This function converts cell values to a value which is a comparison of another value. There is a broad range of comparisons available. It can compared to an aggregate value of an axis, against the current or another page. It can be a specific or relative cell, row, or column, again on the same page or another page.
Syntax:
Compare, compareType, comparison, aggregation, axis, rowCaption, columnCaption, rowIndex, columnIndex, rowLag, columnLag, boolUseRowCaption, boolUseColumnCaption, pageRef
Parameters:
compareType { ToAxis, AbsolutePosition, ToRelativeCell, ToAColumn, ToARow }
comparison { PercentOf , Ratio , Diff, Growth }
aggregation – the aggregating function to use on the axis {Actual, Average, Sum, Maximum, Minimum, First, Last, Median}axis – which axis will be used { Row, Column, Page }
rowCaption – text of row label
columnCaption – text of column label
rowIndex – relative row index, positive is down
columnIndex – relative column index, positive is to the right
rowLag – compare to this number of rows down
columnLag – compare to this number of columns to the right
boolUseRowCaption – use the rowCaption (true) or the rowIndex (false)
boolUseColumnCaption – use the columnCaption (true) or columnIndex (false)
pageRef – page index or caption to use as a reference
Examples:
Compare,ToAxis,PercentOf,Average,Column,,,,,,,False,False,1
Express each cell as a percentage of the column average.
Compare,ToRelativeCell,Diff,Actual,Row,,,,,2,3,False,False,1,
Calculate the difference from the actual value of the cell 2 rows down, 3 columns to the right, on page 1.
Compare,AbsolutePosition,Growth,Actual,Row,1,Food,,,,,True,True,0
For all cells on the page, calculate the growth over the specific cell on row labeled ‘1’, column labeled ‘Food’, page 0.
|
