Home arrow Reference arrow ChangeValuesValues

CONTENT WARNING

This site refers to our older, server-based product. If you are interested in our new, Excel-based product, please see our main web site at http://www.nextanalytics.com

ChangeValuesValues
This function accepts a set of numeric values that define the boundaries of custom groups. It looks at each cell to see if it is less than the value or equal-or-higher-than the value and replaces the cell value with the respective group number.

Syntax:

ChangeValuesValues, boolSortAscending, axis, count, commaDelimitedValues

Parameters:

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

axis – an axis value, but it is not used  { Row, Column, Page }

count – the number of values to follow

commaDelimitedValues – a comma-separated list of numbers

Examples:

ChangeValuesValues,false,Row,2,1000,2000

This example examines each cell and determines if it is below the first value, below the second value, or greater than or equal to it.  In each case, it writes a value of 1, 2, or 3 into each cell. 
 

Reference

Installation - Java