Home arrow Reference arrow CompareSimilar
CompareSimilar
This function converts cell values to a percentage of an aggregate of other rows with the same text columnor row label value.

Syntax:

CompareSimilar, TextColumnCaption, aggregation

Parameters:

TextColumnCaption – enter the exact text of the row label or text columnto be combined.

aggregation – the aggregation to be used when comparing rows {Average, Sum, Maximum, Minimum, First, Last, Median}

Examples:

CompareSimiliar,Sector,Sum

This example looks for unique values in the text column ‘Sector’, and expresses each data cell as a percentage of the Sum of all other rows that have the same Sector.  e.g.  if a specific row has a Sector value of ‘Business’, then the data cell is divided by the Sum (and multiplied by 100 to express as a percentage) of all other rows with ‘Business’ in the ‘Sector’ property.

Comments:

If any columns are selected, the operation only acts on those columns.
 

Reference

Installation - Java