Types of expressions
  • 20 Feb 2023
  • 6 読む分
  • PDF

Types of expressions

  • PDF

The content is currently unavailable in Ja - 日本語. You are viewing the default English version.
記事の要約

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.

Types of expressions_ADD_Asset Category - Records.jpg

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.

The + Expression in the middle of the page is available, only if there are no pre-existing Expressions.

  1. Enter the Expression name in the Name field.

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

The Expression displays SUM where the actual calculation values are to be entered.

Types of expressions_ADD_ADD Expression.jpg

ADD expression

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

Types of expressions_ADD_Drag and Drop.jpg

Drag and Drop

  1. Enter the values required to calculate.

Types of expressions_ADD_Select-Enter values.jpg

Select/Enter values

  1. If required to add more values, click on + icon.
    Types of expressions_ADD_Extra expression value.jpg

Add values

  1. Click Save.

A success message, "Successfully done" appears at the bottom left corner of the screen.

Types of expressions_ADD_Save Expression.jpg

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.

The Expression displays SUB where the actual calculation values are to be entered.

Types of expressions_SUB_Sub Expression.jpg

SUB expression

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

  2. Enter the values required to calculate.

Types of expressions_SUB_Select-Enter Values.jpg

Select/Enter values

  1. Click Save.

Types of expressions_SUB_Save Expression.jpg

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.

The Expression displays MUL where the actual calculation values are to be entered.

Types of expressions_MUL_Mul Expression.jpg

MUL expression

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

  2. Enter the values required to calculate.

Types of expressions_MUL_Select - Enter values.jpg

Select/Enter values

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

Types of expressions_MUL_Add Values.jpg

Add values

  1. Click Save.

Types of expressions_MUL_Save expression.jpg

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.

The Expression displays DIV where the actual calculation values are to be entered.

Types of expressions_DIV_Div Expression.jpg

DIV expression

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

  2. Enter the values required to calculate.

Types of expressions_DIV_Select-Enter values.jpg

Select/Enter values

  1. Click Save.

Types of expressions_DIV_Save Expression.jpg

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.

The Expression displays MIN where the actual calculation values are to be entered.

Types of expressions_MIN_Min Expression.jpg

MIN expression

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

  2. Enter the values required to calculate.

Types of expressions_MIN_Select Enter Values.jpg

Select/Enter values

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

Types of expressions_MIN_Add Value.jpg

Add values

  1. Click Save.

Types of expressions_MIN_Save Expression.jpg

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.

The Expression displays MAX where the actual calculation values are to be entered.

Types of expressions_MAX_Max Expression.jpg

MAX expression

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

  2. Enter the values required to calculate.

Types of expressions_MAX_Select-enter values.jpg

Select/Enter values

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

Types of expressions_MAX_Add value.jpg

Add values

  1. Click Save.

Types of expressions_MAX_Save expression.jpg

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.

The Expression displays MOD where the actual calculation values are to be entered.

Types of expressions_MOD_MOD Expression.jpg

MOD expression

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

  2. Enter the values required to calculate.

Types of expressions_MOD_MOD Select-enter value.jpg

Select/Enter values

  1. Click Save.

Types of expressions_MOD_Save Expression.jpg

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.

The Expression displays LOOKUP where the actual calculation values are to be entered.

Types of expressions_Look up Expression.jpg

LOOKUP expression

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

Types of expressions_Look up Select Table.jpg

Select table

  1. Select the non-key column.

Types of expressions_Look up Non key column.jpg

Non-key column

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

This condition further works as a filter on the key column.

Types of expressions_Add conditions.jpg

Add condition(s)

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

Types of expressions_Select - Constant, Expression and Attribute.jpg

Select - Constant, Expression and Attribute

  1. Click Save.

Types of expressions_Look up Save Expression.jpg

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.

The Expression displays IF where the actual calculation values are to be entered.

Types of expressions_IF Expression.jpg

IF expression

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

Types of expressions_Maximize the screeen.jpg

Maximize the screen

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

Types of expressions_Attributes Selection.jpg

Attributes selection

Types of expressions_Attributes Selection signs.jpg

Attributes selection

Types of expressions_Drop down list.jpg

Drop-down list

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

Types of expressions_Plus icon.jpg

Add more conditions

IF loop can further be continued by adding AND and OR conditions.

  1. Click Save.

Types of expressions_Save IF Expression.jpg

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.

The Expression displays CODE where the actual calculation values are to be entered.

Types of expressions_Type Drop Down List.jpg

Type drop-down list

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

Types of expressions_JS Code Platform.jpg

JS Code platform

  1. Click Save.

Types of expressions_Save Code Expression.jpg

Save Expression


この記事は役に立ちましたか?

What's Next
Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.