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