Home arrow Reference arrow ChangeValuesPercents
ChangeValuesPercents
This function calculates the minimum and maximum values for the designated axis, then divides that into a set of range buckets as per the set of ratios you provide (80% = 0.8). Then it alters the cell values to indicate which range the original value was in.

Syntax:

ChangeValuesPercents, boolSortAscending, axis, count, commaDelimitedRatios

Parameters:

boolSortAscending– lowest values go into bucket 1 (true) or highest values (false)

axis – which axis will be used { Row, Column, Page }

count – the number of percentages to follow

commaDelimitedRatios – a comma-separated list of values, expressed as ratios (80% = 0.8)

Examples:

ChangeValuesPercents,false,Row,2,0.2,0.8

This example calculates the sum of the row, then it examines each cell and determines if it is below 20%, below 80%, or greater than or equal to 80%.  It writes a value of 1, 2, or 3 respectively into each cell.
 

Reference

Installation - Java