Page History
...
- Click the Add calculated field link located at the bottom of the data fields panel.
- A calculated field popup will open. Insert a name for your new column. And use the formula builder to build your calculation.
- Choose a 'Simple Formula' from the formula type drop down.
- Select the fields you want to add to the calculation. The report fields list shows you all the fields you have currently added to your report.
- Use the +-*/ () buttons to add in the arithmetic calculations.
- 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.
- You can validate your calculation to determine whether it will work correctly. Click the validation link to do this.
- Click OK to save your new calculated field. It will now be available in a folder called calculated fields. You will have to drag the new field from the Calculated Fields folder onto your report.
Create a Calculation using a Predefined Formula
...