Page History

Accumulative Percentage

Will print a running percentage for the values returned. A maximum of 100% will be displayed.

Accumulative Total

Will print out a running total for the data returned.

Ascending Rank

The highest value returned will be displayed as a 1. Used where the preferable result is a higher value. Eg. Profit.

Bottom 10 Rank

The bottom 10 values (lowest) are returned.

Bottom N Rank

The bottom N values (lowest) are returned– user is prompted to define number to return.

Delta from Last

Calculate change between consecutive rows

Delta from Last N

Calculate change between the current row and row - N

Descending Rank

The lowest value returned will be displayed as a 1. Used where the preferable result is a lower value. Eg. Expenses.

Difference of Columns

Returns difference of two selected columns

Multiplication of Columns

Returns multiplication of two selected columns

Natural Logarithm

Gives the base e logarithm of the values of a given field.

Natural Logarithm

Gives the base e logarithm of the values in the field.

Percentage Against Absolute Maximum

Returns percentage of selected field according to an absolute maximum value.

Percentage Against Column

Creates a percentage ration of values in the selected column compared to another column.

Percentage Against Maximum

Returns the % of the attribute when compared to the maximum value of the attribute within the dataset.

Percentage of Total

Returns the % of the attribute when compared to the total summed value of the attribute for the entire dataset.

Sum of Columns

Returns the sum of two selected columns.

Top 10 Rank

The top 10 values (highest) are returned.

Top N Rank

The top N values (highest) are returned – user is prompted to define number to return.

Top N With Ties

Returns top values for the selected field with provision for tied values. This means that if there are multiple records per ranking it will restrict it to N total rankings.