Formulae are at the heart of the DataSight Calculation tool. Each Variable or Reference added into a Calculation is represented with a corresponding letter in the formula. The first Variable is a Master Variable, named A, and then additional Variables and/or References are named B, C, etc.

DataSight supports all common mathematical and logical operators, and in addition provides numerous statistical and time dependent transformation options. These operators can be used, for example, to determine minimum, maximum and mean values for different time periods from a record and to determine peaks (instantaneous values) or totals (accumulated values) over a threshold.  Please refer specifically to the following topics for more detail:

• Operators
• Mathematical Functions
• Statistical Functions
• Calculating Differences

Construct a Formula, Check and Format the Result

1. Click within the Formula text box in the Result panel to enter a calculation (or use the pre-filled formula if a saved Calculation Template is open).
2. Any formula entered in the Formula box is checked for potential errors.
   1. Click in the Result preview field, and if the formula is correct, a tick will appear next to the Formula text box and the formula will be coloured green.
   2. Click in the Result preview field, and if the formula is in correct, a cross will appear next to the Formula text box and the formula will be coloured red.
3. Check the resultant value in the Result preview field is displayed as expected. See also Result and Chart Tabs.
4. Scroll through the indexed records using and note the resultant value changes accordingly in the preview field.
5. In the Check the Result you can format your data prior to updating the data in the database. To do this:
6. Click ... to edit formatting. A Display Format - Output box will open.
   • Select the Number of Decimal Places radio button to edit the decimal places. Click the up and down arrows to change the decimal places. By default, this is set to show 3 decimal places (see also DataSight Options to set the default).
   • Select the Scientific radio button to view your results in a scientific format. Click the up and down arrows to change the decimal places in your scientific data. By default, this is set to show 3 decimal places.
   • Select No Formatting to view the actual values that will be saved back to the database, without formatting.
7. Then click OK. Your output will be formatted as required.

Result and Chart Tabs

When you click in the Results preview text box in Calculations, the Results and Chart Tabs are updated with your newly calculated data.  Previewing your data in the Results Tab or Chart Tab is useful prior to the output of data to the database.

The Result tab displays the tabular result of the Calculation.

Here you can see three columns:

• Date and time stamp.
• Values of all Variables open on the datasheet.
• Resulting values post-calculation.

By default, data in the Result tab is sorted by the date and time stamp.

You can choose to export your Calculations result data to a file.

The Chart tab displays the graphical result of the Calculation.

Here you can see two series: Original Variable series, and Result series.

The series are plotted between DateTime and Variable values.

You can choose to export your Calculations chart to a file.

See also:

• Export Calculations