How to Use the ABS Function in WPS on Windows

Last updated:July 23, 2026

Use the ABS function in WPS through 3 how-to topics: create a formula field and call ABS, review the parameter format, and write a working example.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and use ABSFree
22. Check the ABS parameter formatFree
33. Write and verify an exampleFree

How-to Guide

1. Create a formula field and use ABS

Entry path: Add Field → Formula

  1. Open the multidimensional table and go to the table where you want to calculate values.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes ABS in the formula editor.
  5. Click Confirm and check whether the result appears in the formula field right away.

Success Criteria

  • Interface result: A new formula field appears and shows a calculated result.
  • Next action available: You can continue editing the formula or adjust referenced fields.

Tips While Using

  • If the result looks incorrect, first check whether the referenced value is numeric.
  • After saving, the result updates when related data changes.

2. Check the ABS parameter format

Entry path: Formula Editor → Function Library → ABS

  1. Open the editing view for any formula field in the multidimensional table.
  2. Open the function library and find ABS.
  3. Review the parameter format shown for the function.
  4. Enter your target parameter by following the displayed format.

Success Criteria

  • Interface result: The ABS syntax is visible in the function description area.
  • Next action available: You can apply the format directly in the current formula.

Tips While Using

  • Keep the parameter type consistent with the current field or referenced value.
  • Confirm field names and references before entering the formula.

3. Write and verify an example

Entry path: Formula field editor

  1. Create or select a formula field.
  2. Enter an example such as ABS(target_value).
  3. Confirm the formula and review the returned result for the current record.
  4. Change the source data and check whether the formula result refreshes.

Success Criteria

  • Interface result: The formula field returns a non-negative result.
  • Next action available: When source data changes, the result updates automatically.

Tips While Using

  • If you reference a text field, the result may not match expectations.
  • For nested formulas, test ABS first and then add other functions.