Types of expressions

To view the types of Expressions, follow the below mentioned steps:

1. Login to the DL Asset Track™ platform with your Operator credentials.

2. Click on the Asset Category page from the left Navigation Panel.

3. On the Asset Category page, click on the required Asset Category to view the Attributes and Expressions page.

Asset Category - Records

ADD function

This function adds multiple values entered by the Operator.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select ADD from the drop-down list of Field types.

ADD expression

5. Drag and Drop the options available such as Constant, Expression, or Attribute.

Drag and Drop

6. Enter the values required to calculate.

Select/Enter values

7. If required to add more values, click on + icon.
   

Add values

8. Click Save.

Save Expression

SUB function

This function performs subtraction between two values entered by the Operator.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select SUB from the drop-down list of Field types.

SUB expression

5. Drag and Drop the options available, such as Constant, Expression, or Attribute.

6. Enter the values required to calculate.

Select/Enter values

7. Click Save.

Save Expression

MUL function

This function performs multiplication on the multiple values entered by the Operator.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select MUL from the drop-down list of Field types.

MUL expression

5. Drag and Drop the options available, such as Constant, Expression, or Attribute.

6. Enter the values required to calculate.

Select/Enter values

7. If required to add more values, click on + icon.

Add values

8. Click Save.

Save Expression

DIV function

This function divides any two values entered by the Operator, of which one value is the dividend while the other is the divisor.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select DIV from the drop-down list of Field types.

DIV expression

5. Drag and Drop the options available, such as Constant, Expression, or Attribute.

6. Enter the values required to calculate.

Select/Enter values

7. Click Save.

Save Expression

MIN function

This function helps find the minimum value from entered values.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select MIN from the drop-down list of Field types.

MIN expression

5. Drag and Drop the options available, such as Constant, Expression, or Attribute.

6. Enter the values required to calculate.

Select/Enter values

7. If required to add more values, click on + icon.

Add values

8. Click Save.

Save Expression

MAX function

This function helps to find the maximum value from entered values.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select MAX from the drop-down list of Field types.

MAX expression

5. Drag and Drop the options available, such as Constant, Expression, or Attribute.

6. Enter the values required to calculate.

Select/Enter values

7. If required to add more values, click on + icon.

Add values

8. Click Save.

Save Expression

MOD function

This function helps to find the remainder when a number is divided by another.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select MOD from the drop-down list of Field types.

MOD expression

5. Drag and Drop the options available, such as Constant, Expression, or Attribute.

6. Enter the values required to calculate.

Select/Enter values

7. Click Save.

Save Expression

LOOKUP function

The LOOKUP function is used to find non-key values from a master table using a key column value as a filter.

Business use case:
Let's consider an example of an Excel sheet containing the following information:
• Unique ID
• Name
• Contact number
• Address

The LOOKUP function helps in finding the person's information by using their unique ID.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select LOOKUP from the drop-down list of Field types.

LOOKUP expression

5. Under the LOOKUP function, select the desired Master table from the drop-down box.

Select table

6. Select the non-key column.

Non-key column

7. Select the condition you want to set for this Expression.

Add condition(s)

8. Drag and drop function in the text box from the options, such as Constant, Expression, and Attribute.

Select - Constant, Expression and Attribute

9. Click Save.

Save Expression

IF function

The IF loop function is an expression where if a given condition by the operator is satisfied, an entered input value is the result; else, the other entered input value becomes your result.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select IF from the drop-down list of Field types.

IF expression

5. Click the Expand icon to expand the IF loop window.

Maximize the screen

6. Select the desired Attributes from the drop-down list.

Attributes selection

Attributes selection

Drop-down list

7. You can also add more conditions using the + icon.

Add more conditions

8. Click Save.

Save Expression

CODE function

This function allows an Operator to enter their JavaScript code on the platform, you can easily execute any complex logic by using the JavaScript platform by selecting the CODE function.

1. On the Attributes and Expressions page, click on Expressions tab.

2. Next, click on + Expression at the top right corner of the screen.

3. Enter the Expression name in the Name field.

4. Select IF from the drop-down list of Field types.

Type drop-down list

5. If required, select the option of zoom in and zoom out on the JS expression platform.

JS Code platform

6. Click Save.

Save Expression