Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Unified Supply Chain Assay

TABLE OF CONTENTS

Formula

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL
  • Last UpdatedAug 14, 2026
  • 3 minute read

Database field formula configuration

In a Formula column you can display the result of a calculation using any number of properties as variables. Configure the fields as shown in the following table.

Parameter

Description

Example

Unit Category

The category of the unit in which calculated values are reported. You need to choose a category from this list before you can choose a unit from the Unit list.

Density

Unit

The unit of measurement in which calculated values are reported. Any unit supported by the chosen property may be selected from the Unit combo box. For a list of commonly occurring properties and their associated units. See Units.

g/cc

Format

The number format in which calculated values are reported. Calculated values may be shown in any one of a number of numerical formats, including a fixed number of decimal places, a fixed number of significant figures, or scientific notation. For a full list of available format options. See Formats.

4 dp

Variables

The list of variables to be used in the calculation formula.

Add a variable by clicking the Icon Add showing plus sign button, then choose whether the variable refers to a perfect cut (Cut Value) , a flowsheet cut (Flowsheet Cut Value), a Measurement Value, or a Measurement Count.

To edit a variable, select it and click the Icon edit. Shows pencil. button.

To delete a variable, select it and click the Icon remove/delete. Shows red X. button.

X, Y, DEN

Formula

The formula to calculate the value that will be displayed in the View column. For more information on how to write formulae, see Writing Formulae.

(X/Y)*100

Adding and editing variables

Dialog Variable Editor - Cut value, adding and editing variables

When you add or edit a variable, the Variable Editor dialog box opens. Follow these steps to configure a variable:

  1. Choose a Symbol for the variable, which you will use to represent the variable in the formula. Symbols must be unique.

  2. Choose the Property whose value will be stored in the variable.

  3. Choose the Cut for which to report the property. How you do this depends on the option you chose when adding the property, either Cut Value or Flowsheet Cut Value:

    • If you chose Cut Value, select one of the predefined perfect cuts, or define a Custom cut and enter its lower and upper temperature limits.

    • If you chose Flowsheet Cut Value, choose a flowsheet from the left-hand drop-down list, then choose a cut from the right-hand drop-down list. The flowsheet listed are those available in the Flowsheet Manager. See Create a flowsheet.

  4. Choose the Unit in which the variable values are expressed.

  5. Click OK to save your changes and close the dialog box.