Types of expressions
- 20 Feb 2023
- 6 読む分
- 印刷する
- 闇光
- PDF
Types of expressions
- 更新日 20 Feb 2023
- 6 読む分
- 印刷する
- 闇光
- 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:
Login to the DL Asset Track™ platform with your Operator credentials.
Click on the Asset Category page from the left Navigation Panel.
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.
On the Attributes and Expressions page, click on Expressions tab.
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.
Enter the Expression name in the Name field.
Select ADD from the drop-down list of Field types.
The Expression displays SUM where the actual calculation values are to be entered.
ADD expression
- Drag and Drop the options available such as Constant, Expression, or Attribute.
Drag and Drop
- Enter the values required to calculate.
Select/Enter values
- If required to add more values, click on + icon.
Add values
- Click Save.
A success message, "Successfully done" appears at the bottom left corner of the screen.
Save Expression
SUB function
This function performs subtraction between two values entered by the Operator.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select SUB from the drop-down list of Field types.
The Expression displays SUB where the actual calculation values are to be entered.
SUB expression
Drag and Drop the options available, such as Constant, Expression, or Attribute.
Enter the values required to calculate.
Select/Enter values
- Click Save.
Save Expression
MUL function
This function performs multiplication on the multiple values entered by the Operator.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select MUL from the drop-down list of Field types.
The Expression displays MUL where the actual calculation values are to be entered.
MUL expression
Drag and Drop the options available, such as Constant, Expression, or Attribute.
Enter the values required to calculate.
Select/Enter values
- If required to add more values, click on + icon.
Add values
- 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.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select DIV from the drop-down list of Field types.
The Expression displays DIV where the actual calculation values are to be entered.
DIV expression
Drag and Drop the options available, such as Constant, Expression, or Attribute.
Enter the values required to calculate.
Select/Enter values
- Click Save.
Save Expression
MIN function
This function helps find the minimum value from entered values.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select MIN from the drop-down list of Field types.
The Expression displays MIN where the actual calculation values are to be entered.
MIN expression
Drag and Drop the options available, such as Constant, Expression, or Attribute.
Enter the values required to calculate.
Select/Enter values
- If required to add more values, click on + icon.
Add values
- Click Save.
Save Expression
MAX function
This function helps to find the maximum value from entered values.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select MAX from the drop-down list of Field types.
The Expression displays MAX where the actual calculation values are to be entered.
MAX expression
Drag and Drop the options available, such as Constant, Expression, or Attribute.
Enter the values required to calculate.
Select/Enter values
- If required to add more values, click on + icon.
Add values
- Click Save.
Save Expression
MOD function
This function helps to find the remainder when a number is divided by another.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select MOD from the drop-down list of Field types.
The Expression displays MOD where the actual calculation values are to be entered.
MOD expression
Drag and Drop the options available, such as Constant, Expression, or Attribute.
Enter the values required to calculate.
Select/Enter values
- 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.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select LOOKUP from the drop-down list of Field types.
The Expression displays LOOKUP where the actual calculation values are to be entered.
LOOKUP expression
- Under the LOOKUP function, select the desired Master table from the drop-down box.
Select table
- Select the non-key column.
Non-key column
- Select the condition you want to set for this Expression.
This condition further works as a filter on the key column.
Add condition(s)
- Drag and drop function in the text box from the options, such as Constant, Expression, and Attribute.
Select - Constant, Expression and Attribute
- 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.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select IF from the drop-down list of Field types.
The Expression displays IF where the actual calculation values are to be entered.
IF expression
- Click the Expand icon to expand the IF loop window.
Maximize the screen
- Select the desired Attributes from the drop-down list.
Attributes selection
Attributes selection
Drop-down list
- You can also add more conditions using the + icon.
Add more conditions
IF loop can further be continued by adding AND and OR conditions.
- 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.
On the Attributes and Expressions page, click on Expressions tab.
Next, click on + Expression at the top right corner of the screen.
Enter the Expression name in the Name field.
Select IF from the drop-down list of Field types.
The Expression displays CODE where the actual calculation values are to be entered.
Type drop-down list
- If required, select the option of zoom in and zoom out on the JS expression platform.
JS Code platform
- Click Save.
Save Expression
この記事は役に立ちましたか?