Home 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’.
 

Reference

Installation - Java