Contents x
      Post Functions
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      Post Functions

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      Overview

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

      FunctionDescriptionExample

      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 here
      Your content goes here






















      Was this article helpful?
      What's Next