Overview

This article describes setting up Row Formulas and Fixed Value Rows.

• 1.  Row Formulas
• 2.  Fixed Value Rows

1.  Row Formulas

A Dataset Value can be the result of a Row Formula.  Typically, a Row Formula will perform a calculated based on the result of an earlier function or static value in the Dataset.

It is not possible to have a Row Formula for a Dataset Value as well as an underlying Function.  Messages will be displayed to ensure you only have either one against each row.

You can perform basic math operations on the rows using the Row Reference letter.

In the DEMO Dataset, Sales Current Month vs Prior Month Variance value against Row C is the result of Row A Minus Row B as shown below.

2.  Fixed Value Rows

A Dataset Value can be added with a fixed value.

In the DEMO Dataset, Sales Budget Current Month value against Row L is manual value of 50000.

If you need to add a fixed value, simply add a new row, and specify the fixed value in the Value column.

Note that when new rows are added to a dataset, the next alphabetical Row Reference is added automatically.