- 1 Minute to read
- Print
- DarkLight
- PDF
(percent)
- 1 Minute to read
- Print
- DarkLight
- PDF
%
Returns the current row value as a percentage of the resultset total
i.e., the percent of the overall total that is returned by the current row
Purpose
Use this function to:
Calculate the row as a percent of the sum of total value
Calculation
If resultset total = 50, and current row = 5, % returns
% = (5/50 ) * 100
= 0.1 * 100
= 10.00
% = ( RowX / Sum(RowN:Row0) ) * 100
RowN = Last row in result set
Row0 = Second row in result set
Sum(RowN:Row0) = Sum of all rows in result set
RowX = Current Row
Sample Result
Parameters
Parameter | Description |
---|---|
Dimensions | Discrete field(s). All fields must come from the same table. |
Name | Name to be displayed as Column Header in result grid |
Measure | The field to be used in the post-function calculation.
|
Function | COUNT / SUM / AVG / MIN / MAX / STDEV |
Post | % |
Value | Optional. Filter to apply when evaluating FUNCTION. Only records in the Filter Recordset will be included in the Function and Post-Function calculations. Must come from same table as DIMENSION/MEASURE or be linked to the Dimension table. |
Axis | 0 / 1. Y-Axis to use when plotting graph. Default = 0 |
Plot | Y / N. Specifies whether measure’s output column should be plotted on graph. Default = Y |
Resolve | Optional. Resolve level for the measure. If blank, Resolve = Dimension Table |
Series Type | Default / Bar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose Determines the graph style for the measure. |
Popup | Default / None / Extended |
Prefix | $ / £ / E / % |
Usage Notes
% depends on the number of rows brought back from the engine (options: row count)
See Multi-Function Profile / Options for details of how to control the number of rows in a result set
Example
NOTE: Measure 1 is included purely for illustration. It is not necessary to include this measure for the calculation to work.
Example use: percent of overall sales
Dimension:[transactions].[date]
Measure 1
| Measure 2
|