Formula

Demonstration to illustrate the Formula step.

In this guided demonstration, you will:

• Configure the following steps:

  • Formula

Formula

1. Generate rows

Generate rows outputs a specified number of rows. By default, the rows are empty; however, they can contain several static fields. This step is used primarily for testing purposes. It may be useful for generating a fixed number of rows, for example, you want exactly 12 rows for 12 months.

Sometimes you may use Generate Rows to generate one row that is an initiating point for your transformation. For example, you might generate one row that contains two or three field values that you might use to parameterize your SQL and then generate the real rows.

Used to generate some testing data:

a = 1

b = 2

booking_type = R

Generate rows

2. Formula

The Formula step can calculate Formula Expressions within a data stream. It can be used to create simple calculations like [A]+[B] or more complex business logic with a lot of nested if / then logic.

Workflow 1

Simple formula: result = [a] + [b]

Formula - [a]+[b]

Workflow 2

Logic: result = IF([booking_type]=”R”;[b]-[a])

Formula - IF([booking_type]=”R”;[b]-[a])

The datastream fields are referenced: [ datastream]

http://wiki.pentaho.com/display/Reporting/Formula+Expressionswiki.pentaho.com

OASIS Open Document Format for Office Applications (OpenDocument) Version 1.2 - Part 2: Recalculated Formula (OpenFormula) Format

Link to OASIS Open Document Format