Operator fields

Application management : Business intelligence & reporting : Reports : Field descriptions : Operator fields

Operator fields

Operators in expressions serve multiple purposes in Planon ProCenter 's reporting functionality. They allow users to perform calculations and operations on fields within report definitions.

These operators can be used to create additional columns in reports, combining or manipulating data from existing fields.

By utilizing these operators, users can create customized and dynamic reports that perform calculations, apply filters, and present data in more meaningful ways.

Operator	Description	Example
+	Addition (numeric) Adds one value to another	Budgets.'Total invoiced/actual costs' +Budgets.'Remaining budget'
	Concatenation (strings) Appends strings See Text constant for an example.	Personnel.'First name' + Personnel.Surname
-	Subtraction Subtracts one value from another	Budgets.Budget -Budgets.'Total invoiced/actual costs'
*	Multiplication Multiplies one value by another	Budgets.'% of budget category' * 0.95
/	Division Divides one value by another	Budgets.'Remaining budget'/ 12
%	Modulo or remainder operator. This operator returns the remainder of a division. Example 5 % 2 = 1	Orders.Workplace.'Surface area' % Orders.'Number of people'
=	Equals Returns items that match the value following the equal sign	Orders.'User-defined status'.Code = "O1"
<	Less than Returns items that are less than a specified value	Orders.'User-defined status'.Code < "O2"
>	Greater than Returns items that are greater than a specified value	Orders.'User-defined status'.Code > "O1"
!=	Does not equal Returns items that are not equal to a specified value	Orders.'User-defined status'.Code != "O1"
<=	Less than or equal Returns items that are less than or equal to a specified value	Orders.'User-defined status'.Code<="O2"
>=	Greater than or equal Returns items that are greater than or equal to a specified value	Orders.'User-defined status'.Code >= "O2"
and	Logical AND Results in an expression that checks on both parameters	Orders.Property.'Property code' = "41008" and Orders.'Requested completion date' = currentDate()
or	Logical OR Returns items for which one of the parameters is true	Orders.'Number of people' = 8 or Orders.'Number of people' = 9
not	Logical NOT Returns items for which none of the parameters is true	not (Orders.'Number of people' = 8 or Orders.'Number of people' = 9)
If () then else	If then else Returns items matching the query as 1 and other items as 0	( if (not( Orders.'Transferred to archive (Y/N)') )then (Orders.Number))