ABS() Function

YouTube: How to Use the ABS() Function in Report Custom Columns?

How to Use the ABS() Function in Report Custom Columns?

In this tutorial, we will learn how to create a custom expression using the ABS function, which converts negative numbers into positive values. Let’s begin!

Accessing the Expression Designer:

• Navigate to the Reporting section.

• Open the Sales Register Detailed Report or any "Report".

• Go to Setup Column Attributes.

• Here, you'll see a list of available columns that can be used to build expressions.

• Click on "Add/Edit Expression Columns" where you can write your expression using predefined functions.

• Before adding the expression to the report, go to Other Settings.

• Ensure the Script Editor is set to VBScript.

• Click Save.

  • Note: VBScript is the default for new configurations but always verify this setting.

Writing Your First Expression

• Every expression must start with the script header: '#@LSCRIPT

• Click the (+) Plus icon to create a new expression.

• Fill in the required fields:

  • Expression Name – A unique name for your expression.

  • Expression Type – Choose either Text or Numeric depending on the expected output.

Creating a Simple ABS() Expression

• Double-click your newly created expression to insert it into the script editor.

• Define the expression using the syntax:

  • Expression Name = ABS("GROSS_AMOUNT")

• Save the expression once defined.

• Scroll down and check the box beside the expression name to enable it.

• Save and proceed to check the effect.

• Refresh the report to view the final result.

• The column will now display only positive values, regardless of whether the original number was negative or positive.

• Example:

  • Original GROSS_AMOUNT: -2350.82

  • Output with ABS_GRS_AMT: 2350.82