Custom formulas

You can create a new value out of existing field values, similar to what you can do in a spreadsheet. There are three options for formulas:

Roll-up

A roll-up is the sum of different field values.

Example

A roll-up formula is created using Insights and Votes as inputs.

Weighted Score

A weighted score helps understand the value of an idea relative to other ideas in the project using normalization.

What is normalization?

Normalization is an operation that takes all field values across all ideas in a project.

• 0 is taken as the minimal value. Alternatively, we take the lowest number if you are using negative numbers.

• 100 is the highest field value.

• All values are then plotted based on their relative value between the lowest and 100.

Examples

In the following example, we give a weighted score based on a single rating field. A rating of 5/5 equals 100, and 4/5 equals 80.

You have positive and negative numbers

If you have both positive and negative numbers, the smallest number will be used as the minimal value.

If you only have negative numbers

If you only have negative numbers, the highest negative number is used as the maximum value.

If you only have positive numbers

If you only have positive numbers, 0 is the minimum value.

Formulas

We have 2 cases:

1. We only have positive weights defined - we wind up with a normalized sum of all normalized field values multiplied by their weights.

2. We have at least one negative weight, and the calculation is done by dividing the normalized sum of all positive inputs’ normalized field value multiplied by their weights by the normalized sum of all negative input’s normalized field value multiplied by their weights.

Write Your Own

You can write your own formula using a simple expression language: