---
title: "Post Functions"
slug: "post-functions"
updated: 2021-10-12T12:56:09Z
published: 2021-10-12T12:56:09Z
canonical: "docs.datajet.app/post-functions"
---

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

# Post Functions

## Overview

Post Functions allow inter-row calculations to be carried out on a basic profile result set.

| Function | Description | Example |
| --- | --- | --- |
| ## **log** | #### Returns the natural logarithm of the specified measure. log=Loge.Measure **log= ln(RowX)** ***RowX*** *= value for current row* ***ln****= loge* | If measure = 97,825, what power must e (2.7182818) be raised to in order to get 97,825? log(97,825) = 11.49 or e11.49=97,825 |
| ## delta | ### Returns the difference between RowX and Row(X-1) for the specified measure i.e., Subtracts the previous row from the current row. First row is NULL Note: To return the first row as 0.00 use the zdelta function instead. The order of the dimensions is important as this will affect the inter-row calculations. Sort by Label or Value, Ascending or Descending. Can be used with multiple dimensions as calculates difference between each row. **delta = RowX - Row(X-1)** ***RowX*** *= value for current row* ***Row(X-1)*** *= value for previous row* ***delta****= RowX - Row(X-1)* | Example use: Calculate difference in sales from one month to the next (Month on Previous Month) *e.g Sales difference by month* Table: Transactions Dimension: [Transactions].[YearMonth] NOTE: Measure 1 is included purely for illustration. It is not necessary to include this measure for the calculation to work. Measure1: [Transactions].[CastPrice], SUM Measure 2: [Transactions].[CastPrice], SUM, **delta** Your title goes hereYour content goes here |
|  |  |  |
|  |  |  |
|  |  |  |
|  |  |  |
|  |  |  |
|  |  |  |
|  |  |  |

###