Neara Reports also support creating powerful, complex formulas that operate inside table cells. You can use formulas in reports to, for example:
Perform calculations such as a custom length check of conductor spans
Conduct comparisons and return a Pass or Fail result
Create a new property of an object such as a pole or conductor
Generate visualizations that appear on the Perspective, Profile, Analytics Maps, and other views
For more information about the features available in Neara's powerful formula expression language, including examples, see the Formula Language Reference section
Adding a formula to a Report
To create a formula inside a Report, start by creating a new column in a Report table by clicking the + icon in any column header in the Report:
This will insert a new column to the left of the existing column.
In the header of the new column, click the configuration (gear) icon to see the column configuration popup:
The values from the Field will provide data to the cells in your new column. Normally when adding columns to Reports you would select an existing field to populate data in the cells.
To use a custom formula instead of selecting an existing field from the suggestions, start typing a new name in the box, for example: u_clearance_check and then click the Add new custom field option that appears:
The custom field's name can be anything you like (so long as it doesn't conflict with an existing field name) but we recommend using a standard prefix for your custom formula fields to make it easy to identify them in future.
The popup will expand to show a space to add the formula, and an option to add a Description to help other users understand the field's purpose and result:
Give the column a friendly Title, too - one may be automatically suggested for you.
When you are happy with your formula and it contains no errors, click Save and click outside the popup to dismiss it. The column should now contain data on each row matching the results of your formula.
Example formulas are provided below.
The Schema Editor
For easier formula editing, click the Schema Editor option that appears when you hover your mouse over the Formula box in the column configuration popup:
The Schema Editor provides a larger editing space for your current formula. Click inside your formula for help tips on any built-in formula functions:
In the Documentation tab, you can find a categorised list of all the built-in formula functions available for use. Each function contains extensive documentation and example usages.
