| Table of Contents |
|---|
...
To concatenate several And/or conditions, add parentheses for each condition, as in the following example: IF(('unit_is_stationary' = 'Yes')&&('unit_is_stationary' = 'Yes'); 'OK';'Not OK')
Single quotes are supported inside a value only by prefixing them with the escape string(\) i.e. a formula
can look like this: 'unit_name' + ' Te\'st' and the result will be unit name Test
...
Calculation Field Creation
...
Click on the “+Add Field” and choose the “Calculated Field”. This action will open the calculation fields wizard.
...
Give the calculated field a name
Choose the relevant field then click one of the mathematical symbols and choose another field. You will see all the formulas in the “formula field”. For example, you can multiply the “Engine Hours“ by the “Current”. In the end, you need to click “Save”
...
The calculated field available at the reports' output, as any other field.
...
Additional notes:
As with any standard report field, the calculated field name can be changed, and filtering functionality is fully supported!
Regular Expression
Galooli reports system allows you to perform a variety of advanced filtering manipulations without using third-party solutions such as Excel.
...