...
Calculated fields allow you to create basic calculations with the fields available in your report.
Note: a calculated field that you create in the report builder cannot be used across multiple reports. It is unique to your report only. If you create a set of calculated fields you wish to use across multiple reports you can either:
...
| Expand |
|---|
| title | Click to view instructions... |
|---|
|
- Click the + button at the bottom of the field list in the Data step of the report builder.
 - The Calculated Field window will now appear. You will need to define the following:
- Provide a name for your formula in the Calculated Field Name box. This will be used as the field name in your table and/or chart output.
- Select Simple from the Formula Type drop down list.
- Use the formula buttons and field drop down list to add components to your calculation. You cannot type directly into the calculation area of the window, each part of the formula needs to be added using buttons. Yellowfin will not permit you to select combinations of variables that are incompatible – therefore options that are greyed out will become active as you add in elements.
Note: if you wish to type your calculation you may need to use the Freehand SQL option discussed later.
- Once finished click the Validate button to ensure your calculation is not missing any components.
 - Click Save to complete your calculation. It will now be available in a folder called calculated fields at the bottom of the field list in the Data step.
|
...
| Expand |
|---|
| title | Click to view instructions... |
|---|
|
- Click the + button at the bottom of the field list in the Data step of the report builder.
- The Calculated Field window will now appear. You will need to define the following:
- Provide a name for your formula in the Calculated Field Name box. This will be used as the field name in your table and/or chart output.
- Select Freehand SQL from the Formula Type drop down list.
- Enter the SQL use wish to use to populate the field.
Note: The Freehand SQL builder will require: - An SQL SELECT fragment, not including the SELECT keyword or any FROM or WHERE clauses
- Columns referenced to exist in the view
- No aggregate functions (AVG, MIN, MAX, SUM, and COUNT) should be used.
- Once finished click the Validate button to ensure your calculation is not missing any components.
 - Click Save to complete your calculation. It will now be available in a folder called calculated fields at the bottom of the field list in the Data step.
|
...