Formulas

Owned by Migration
Last updated: Oct 16, 2017 by Jeroen de Soeten (Unlicensed)

Introduction

Formulas can be used to calculate list values. All input values for the formula must come from the same list. If the value that you want to calculate needs to be part of many lists or the calculations are multi dimensional you can consider using /wiki/spaces/CXO63/pages/109218282 instead.

Create a Formula

To create a Formula, you shoud click on the Formula Field in the Content Panel (List)

CONTENT


You can choose several types of Formulas:

TypeDescriptionFormulaOption
SummationSum(Item+Item+Item+etc.) 
SummationRangeSum Range(Item:Item) 
AverageAverage(Item, Item, Item, etc.) 
AverageRange Average Range(Item:Item) 
Variance FormulaVariance(Item-Item)Absolute / Relative
RatioRatio(Item/Item)Absolute / Percentage
MultiplierMultiplier(Item*Item) 

Subtracting two values

The formula editors does not include a subtract function. In order to subtract one value from another, the user should choose the Summation formula and click on the sign which will change onto 

The Average Range and Summation Range do not show the exact averages and summations

The AverageRange and SummationRange functions calculate the average or the summation of a range of items in a list, with one exception: when an item is set to invisible, it is not included in the AverageRange or SummationRange total.

So in the case where these functions do not show the correct value, please check the visible settings of the rows included in the range.

Add a description to a formula

To add a description to a formula, enter the description in the Custom Description field of the Item List.

Second Pass

Is an option when the conflicting formula on the row or columns should be calculated after each other. (where second pass is checked will be calculated as last).