Please Wait...

Software FAQs

Am I able to add columns that allow numerical data or formula in PHAWorks RA Edition?

Numerical data or Formula columns can be added using the context menu (Add Column) by right clicking on a worksheet column heading.

Select the Type of Column to Add

When adding columns, you must first select the type of column required and then follow the wizard

  • Primary - Used for entry of text information and is the only column that can have child columns associated with it.
  • Attribute (Standard) - Only one entry allowed for each parent entry
  • Attribute (List) - One or more entries allowed for each parent entry
  • Attribute (Date) - Date value for selected parent entry
  • Attribute (Checkbox) - Provide a yes / no designation for entries.
  • Numerical - Stores and validates information as a numerical value.
  • Formula - Provides a field for user entered formulas.

After the column has been created, you place the mouse cursor over the column heading and select Specify Formula for <column name> in the context menu.

You click on the function selection icon to select functions for the formula and on the column selection icon to select columns for the formula. For functions that use COLUMNS, only those numbers within the span
of the parent column are included.

You can select what columns to be used when creating the formula. Use the expand arrow to access individual columns. Replace the text COLUMN in functions with the name of specific columns to use in the formula. When column can be used with the same name (e.g., S), we also show the group name (e.g., Risk After Safeguards / S).

The formula can be combination of multiple functions and columns, an individual function, function and column, just the column value, or simple math. In the context menu there is an option Insert Operator that provides the following symbols which can be used for math formulas.

Example image for Numerical and Formula columns

Back to Software FAQs

Related Topics