Skip to main content

Difference

Syntax​

Field               field1
Sum
Field               field2
Difference
Field               destination_field

Parameters​

  • field1: The field containing the initial value (minuend).
  • field2: The field containing the value to subtract (subtrahend).
  • destination_field: The field where the result will be stored.

Description​

Calculates the difference between two specified database fields and stores the result in a third field.

Remarks​

This command is used for performing subtraction on data within database fields, not on event times. It can be used with both numeric and time-formatted fields.

Examples​

To subtract the time in TIME2 from TIME1 and store the result in TIME3:

Field               TIME1
Sum
Field               TIME2
Difference
Field               TIME3