Functions in ProductEngine

ProductEngine displays information in rows and columns. Each row represents a product line item while columns show data associated with these line items.

Compared to traditional spreadsheet software, ProductEngine functions reference columns instead of individual cells. This means that functions will always refer to the values that belong on the same row (or product line item) as the function itself.

This will become more obvious as we show how functions work in the following sections.

Referencing Column Keys

As mentioned before, functions reference columns not cells. Columns are referenced using a column's Column Key.

A Column Key is generated by ProductEngine when a column is created. ProductEngine uses the Column Label (or name) to generate a Column Key with the format of $columnLabel. Later changes to the Column Label will not change the Column Key.

This is illustrated in the screenshot below where a column called New Column Label is created. This causes ProductEngine to generate a Column Key called $newColumnLabel

To find the Column Key for an existing column, you need access to the Column Options which can be accessed by

In the Column Options the Column Key will be displayed under the Column Key heading with an icon next to it that will copy the Column Key to your clipboard.

How to use functions

Functions can be used either in a cell or as a column default.

Using functions in a cell