Create a Layout Calculation

Create a layout calculation to add run-time information to your report, such as current date, current time, user name, and a baseline in a visualization.

When creating layout calculations, only report functions are available to you in the expression editor. These functions are executed in the report layout, as opposed to the other functions which are executed in the query.

Procedure

  1. Click the Toolbox icon The toolbox icon and drag Layout calculation to the report.
  2. In the Available Components box, define the calculation:
    • To add data items from a specific query, on the queries tab queries icon, double-click data items.
    • To add functions, summaries, and operators, on the functions tab functions tab, double-click elements.
    • To add a value that is derived from a parameter, on the parameters tab parameters tab, double-click a parameter.

      Parameters define prompts, drill-through reports, and master detail relationships.

    Tip: You can also type the expression directly in the Expression Definition box.
  3. Click the validate button validate icon.