Hitachi Vantara Pentaho Community Wiki

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


  1. In the Design panel, select a field to which you want to associate a formula.
  2. Click Report Functions in the upper right panel.
  3. Click Add Function to Report in the Properties panel.
  4. Select the newly created function.
  5. In the Properties panel, click Set Properties to open the Formula Editor.
  6. In the Formula Editor dialog box, select a Category from the list.  The Function list is populated with the functions that are most appropriate for the category you selected.
  7. Select the appropriate function. When you select and double-click a function, the Report Editor displays the formula expression (the equation and relevant parameters); it also displays the Return Type and Description as shown in the example below: