Version 5.1.2.0
This document contains confidential information. Not to be copied by third parties without written authorization.
© Copyright Corporater AS - All rights reserved.
IF-THEN-ELSE is a function that works in the same way as other logical tests, e.g. that are used in Excel and SQL. It is often used with AND and OR.
This function may be defined in many different ways, and the syntax has this structure:
IF <comparisonExpression> THEN <expression> ELSE <expression>
This function is often used when there are several conditions that must be met in order to decide which value a KPI should be given.
An example of this is Turnover. It is not good if too many employees leave a company, but it may also be a bad sign if no one leaves. Using IF-THEN-ELSE in a Function status makes it possible to create status light limits beyond what you can do with ordinary limits.
In the example below, the user tests whether Turnover (node [142]) is either higher than 5% or lower than 1%. If so the KPI is given a value of 5%. If it is between the two limit values the node is given its actual value.
IF [142]>0.05 or [142]<0.01 THEN 0.05 ELSE [142]
Version 5.1.2.0
This document contains confidential information. Not to be copied by third parties without written authorization.
© Copyright Corporater AS - All rights reserved.