Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 7 Next »

Overview

Unknown macro: {styleclass}

[top]

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:

  1. Request the calculations to be included in the View by your administrator or
  2. Copy the report containing the calculations using the copy function - the copied report will contain the new calculated fields as well.

Why Use Calculated Fields?

When an administrator designs a View they may not create all the variables that you are likely to need in the course of your report writing. The intention of a view is to provide you with sufficient fields for you to be able to write the report you need and to use some of these fields as the basis for more complex calculations.

Simple Formula

Unknown macro: {styleclass}

[top]

Simple Formulas allow you to build calculations using the formula builder button interface. These may range from very simple addition or multiplication through to CASE statements.

 Click to view instructions...
  1. Click the + button at the bottom of the field list in the Data step of the report builder.
  2. The Calculated Field window will now appear. You will need to define the following:
    1. 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.
    2. Select Simple from the Formula Type drop down list.
    3. 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.
  3. Once finished click the Validate button to ensure your calculation is not missing any components.
  4. 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.

Pre-Defined Formula

Unknown macro: {styleclass}

[top]

Using a pre-defined formula you can add calculation to your report that will be based on formula rules defined by an administrator or are system default.

 Click to view instructions...
  1. Click the + button at the bottom of the field list in the Data step of the report builder.
  2. The Calculated Field window will now appear. You will need to define the following:
    1. 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.
    2. Select Pre-Defined from the Formula Type drop down list.
    3. Choose the formula you wish to apply - the selection is specific to the type of database that your data is sourced from.
    4. You will now be provided with options to complete your calculation. Click on each parameter to define it.
    5. Provide a value using one of the options provided. These will vary depending on the type of value required.
  3. Click Save to complete your calculation.
  4. Your calculation will now be available in a folder called calculated fields at the bottom of the field list in the Data step.

Freehand SQL

Unknown macro: {styleclass}

[top]

If you have SQL skills you may wish to write your SQL directly into the SQL edit box. In this case select the 'Enter SQL' option from the formula tab. This will open the SQL edit box.
Insert the SQL you wish to create your column.

 Click to view instructions...
  1. Click the + button at the bottom of the field list in the Data step of the report builder.
  2. The Calculated Field window will now appear. You will need to define the following:
    1. 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.
    2. Select Freehand SQL from the Formula Type drop down list.
    3. Enter the SQL use wish to use to populate the field.
      Note: The Freehand SQL builder will require:
      1. An SQL SELECT fragment, not including the SELECT keyword or any FROM or WHERE clauses
      2. Columns referenced to exist in the view
      3. No aggregate functions (AVG, MIN, MAX, SUM, and COUNT) should be used.
  3. Once finished click the Validate button to ensure your calculation is not missing any components.
  4. 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.

Edit a Calculated Field

Unknown macro: {styleclass}

[top]

  1. To edit a formula for a calculated field open the Calculated Fields folder.
  2. Select the field you wish the edit. It should be highlighted and an edit icon will be visible at the right of the field's name.
  3. Click the edit icon and the formula popup will open.
  4. Edit your formula and click OK when completed to close the popup and save your changes.

Delete a Calculated Field

Unknown macro: {styleclass}

[top]

To delete a calculated field from your report entirely

  1. Select the field from the calculated field category
  2. Click the edit icon and the formula popup will open
  3. Click the delete link to delete the field. The popup will close and return you to the report page.



Unknown macro: {horizontalrule}
Unknown macro: {styleclass}

[top]

  • No labels