Contents x
      LMath Overview
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      LMath Overview

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

      LMath Functions

      LMath functions produce INTEGER fields from inputs ranging from A-E (depending on the function)

      Purpose

      Use LMATH functions to:
      • Convert a double to an integer
      • Manipulate integer data

      Return Value

      PropertyValueNotes
      FieldTypeIntegerLMATH functions always return an Integer
      FieldSizeLow, Med. HighMed - Up to 65,630 unique values
      High  - up to 1,000,000 unique values
      Continuous - greater than 1,000,000 unique values
      DataTypeDiscrete/ ContinuousDepends on inputs and calculation
      DataSizeShort / Integer


      Example Return Value: X...-X

e.g.  21, 98754654, -5, -654

      Data View

      Quick Profiler and Tree view

      Parameters

      ParameterJSONDescription
      Table“targetTable”: “MyTableName”The target table on which the new field will be created
      Filter“dataset”: {DataSet_JSON}Optional.   If a filter is applied, records not in the filter recordset will be returned as null.
      Function"function":"lmath"
      MATH Function“p1”: “”Select the LMATH function from the drop-down list.
      Specifies the function to use.
      A -E
      		“p2-7”: “FieldName”
      “p2-7”: “#N*”      		Fields to use for the values A-D.   Alternatively, a field can be replaced with a Fixed Value.  Fixed values must be preceded by the hash symbol (#).
      Supports:  
      • DataType: Discrete / Continuous
      • Field Type: All
      • Fixed Value:  #N*    e.g. #201596,    #-87  #mystringvalue  
      Name"name" : "FieldName"Required.   The name of the field to create.  

      JSON Sample


      Usage Notes

      See Also:   



      Was this article helpful?
      What's Next