How-To

Global Reference Value

Sigma allows you to define a value that can be easily viewed and easily changed as needed.

The totals bar in your Worksheet can be used to set values that can then be referenced in calculations throughout your Worksheet. This allows you to define a value that can be easily viewed and easily changed as needed.

To create a new Global Reference Value:

  1. Select “New Total” from the top Tool Bar.
  2. Enter in your value.
  3. Rename your value. You may want to use a naming convention that sets your entered values off from calculated totals.
  4. Reference you value throughout your Worksheet the same way you reference other columns in the Worksheet.