Need an account? Click to Register
Home arrow Learn arrow Reference arrow ChangeValuesAboveBelowAggregation
ChangeValuesAboveBelowAggregation
This function calculates the aggregate value of the designated axis, and then alters the cell value to indicate if it was below, or equal-or-above the aggregate.

Syntax:

ChangeValuesAboveBelowAggregation, boolSortAscending, axis, aggregation

Parameters:

boolSortAscending– lowest values go into bucket 1 (true) or highest values (false)axis – which axis will be used { Row, Column, Page } aggregation – the type of aggregation to be used (Average, Median)

Examples:

ChangeValuesAboveBelowAggregation,false,Row,Average

This example calculates the row average and then examines each cell. If it is below average, it is written as ‘1’ otherwise it is written as ‘2’.
 
< Prev   Next >

Reference