---
title: "(percent)"
slug: "percent"
updated: 2023-03-21T11:49:42Z
published: 2023-03-21T11:49:42Z
canonical: "docs.datajet.app/percent"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.datajet.app/llms.txt
> Use this file to discover all available pages before exploring further.

# (percent)

%

### 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. - Must be numeric if Function is anything other than COUNT. - Must come from same table as DIMENSIONS. - Supports Discrete or Continuous DataTypes. |
| 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 - Name: = Sum sales - Measure: = transactions.castprice - Function: = Sum - Post: = - Value: = - Axis: =0 - Plot:=Y - Resolve:= - Series Type:=Bar - Popup:=Default - Prefix:= | #### Measure 2 - Name: = Percent of total - Measure: = transactions.castprice - Function: = Sum - Post: = % - Value: = - Axis: =0 - Plot:=Y - Resolve:= - Series Type:=Line - Popup:=Default - Prefix:= |
| --- | --- |

#### ![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1679399271479.png)

![](https://cdn.document360.io/73b6469b-c1e4-47e9-aa65-986c8ebd17ca/Images/Documentation/image-1679399281619.png)

####