---
title: "FLogic Overview"
slug: "lmath-overview"
updated: 2023-08-17T06:45:07Z
published: 2023-08-17T06:45:07Z
canonical: "docs.datajet.app/lmath-overview"
---

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

# LMath Overview

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

| Property | Value | Notes |
| --- | --- | --- |
| **FieldType** | Integer | LMATH functions always return an Integer |
| **FieldSize** | Low, Med. High | Med - Up to 65,630 unique values High - up to 1,000,000 unique values Continuous - greater than 1,000,000 unique values |
| **DataType** | Discrete/ Continuous | Depends on inputs and calculation |
| **DataSize** | Short / Integer |  |

```powershell
Example Return Value: X...-X

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

### Data View

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

### Quick Profiler and Tree view

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

## Parameters

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

| Parameter | JSON | Description |
| --- | --- | --- |
| **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

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

### Usage Notes

See Also:

- [Field and Table Names](/v1/docs/generaltemplate)
- [Engineering | Expression Field](/v1/docs/expression-field)

##