Contents x
      ColumnMath
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      ColumnMath

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

      Allows new columns to be added to the result set by applying expressions to existing result set column

      Purpose

      Use this function to:

      • Perform mathematical operations on result set columns

      Parameters

      ParameterDescription
      Column NameRequired.  The name of the output column to create.
      Expression

      Required. Mathematical expression.

      Supported operators:  + - * ÷ ( )

      Operations can be performed on columns or definite values.

      e.g.

      • [Column1] * 2      :  multiplies Column1 by 2
      • [Column1] * [Column2]   :  multiplies Column1 by Column2

      Column names must be in square brackets [ ] and must reference columns that are created via measures or via earlier post-processing columns.

      Result TypeInteger / Double / dpercent / ipercent
      Plot Axis0 / 1. Y-Axis to use when plotting graph. Default = 0
      Plot AsBar / Stacked Bar / Line / Spline / RangeLow / RangeHigh / CSLow / CSHigh / CSOpen / CSClose
      Determines the graph style for the output column.
      PlotY / N. Specifies whether measure’s output column should be plotted on graph. Default = Y
      Popup ModeDefault / None / Extended
      Prefix£ / $ / E / %
      Null as 0

      Examples















       

      Was this article helpful?
      What's Next