---
title: "2dzdelta0"
slug: "2dzdelta0"
updated: 2023-03-21T12:29:24Z
published: 2023-03-21T12:29:24Z
canonical: "docs.datajet.app/2dzdelta0"
---

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

# 2dzdelta0

2dzdelta0

### Returns the difference between the current row and previous row for the specified measure, resetting each time dimension 1 changes

Requires 2 dimensions (2d)

*If only 1 dimensions specified, will always return Current Row (RowX)*

Calculates difference between rows (delta)

Resets to Current Row (RowX) each time dimension 1 changes (0)

## Purpose

Use this function to:

- Calculate monthly change in sales, resetting at start of each year.

## Calculation

**2dzdelta0 = RowX - Row(X-1)**

***RowX** = value for current row* ***Row(X-1)** = value for previous row* ***2ddelta0** = RowX - Row(X-1)*

## Sample Result

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

### 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 | 2dzdelta0 |
| 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

Row order is important when working with deltas. Set row order using Ascending / Descending Value/Labels

2d**z**delta0 is the same as [2ddelta0](https://datajetsoftware.atlassian.net/wiki/spaces/ED/pages/493387795) except that if the delta returns a null, zdelta will return 0.00

Use 2d**z**delta if null values need to be treated as if they were zeros.

## Example

NOTE: Measure 1 is included purely for illustration. It is not necessary to include this measure for the calculation to work.

Example use: Changes in sales, for product, by group

#### Dimension: [transactions].[product_group], [transactions].[productid]

| #### Measure 1 - Name: = COUNT - Measure: =[transactions].[cid] - Function: =count - Post: = - Value: = - Axis: =0 - Plot:=Y - Resolve:= - Series Type:=Default - Popup:=Default - Prefix:= | #### Measure 2 - Name: = 2ddelta0 - Measure: =[transactions].[cid] - Function: =count - **Post: = 2dzdelta0** - Value: = - Axis: =0 - Plot:=Y - Resolve:= - Series Type:=Default - Popup:=Default - Prefix:= |
| --- | --- |

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

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

####