Page Comparison

If

Check if 'Condition' is met. Returns 'ValueIfTrue' is it does, otherwise returns 'ValueIfFalse'.

Example: IF([Status] = “Disconnected”, “Disconnected”, “Connected”)

MIN

Returns the smallest number in a set of numeric expressions. Can be used to compare multiple values.

Example: MIN([Tenant 1 Total [KWH]], [Tenant 2 Total [KWH]], [Tenant 3 Total [KWH]])

MAX

Returns the largest number in a set of values. Can be used to compare multiple values.

Example: MAX([Tenant 1 Total [KWH]], [Tenant 2 Total [KWH]], [Tenant 3 Total [KWH]])

AVERAGE

Returns the average of the arguments. Can get multiple values as arguments.

Example: AVG([Site_Global.Grid_V1 [V]], [Site_Global.Grid_V2 [V]], [Site_Global.Grid_V3 [V]])

ABS

Returns the absolute value of a number.

Example: ABS([Site_Global.Battery_Power [W]]

CONTAINS

Returns true if "String" contains "Substring", and false otherwise.

Example: IF(CONTAINS([site layout], "OFFGRID"), "off-grid", "on-grid")

COUNT EQUALS

Counts how many of the listed fields are equal to the value.

It is possible to enter a textual, numeric, or date value.

Example: COUNTEQUALS (“Yes”,[Tenant_1.Configured],[Tenant_2.Configured],[Tenant_3.Configured])

AND

Check whether all arguments are true, and return true/false respectively. Can get multiple values as arguments.

Example: AND([Smart_Battery_1.Disconnected] = "No", [Smart_Battery_2.Disconnected] = "No")

OR

Check whether any of arguments are true, and return true/false respectively. Can get multiple values as arguments.

Example: OR([Smart_Battery_1.Disconnected] = "No", [Smart_Battery_2.Disconnected] = "No")

+

Add to numeric expressions, or concatenate textual expressions.

-

Redact from numeric expressions. Arguments can only be numeric expressions.

\

Divides numeric expressions. Arguments can only be numeric expressions.

*

Multiplies numeric expressions. Arguments can only be numeric expressions.

^

Exponentiation of numeric expressions. Arguments can only be numeric expressions.

=

Check if the expressions are equal. Can be used to compare numeric, text or dates expressions.

!

Changes False expressions to True, and True expressions to False.

Example: [Unit Id] != 8000000

<=

Check if A is smaller than or equals to B. Can be used to compare numeric or dates expressions.

>=

Check if A is greater than or equals to B. Can be used to compare numeric or dates expressions.

<

Check if A is smaller than B. Can be used to compare numeric or dates expressions.

>

Check if A is greater than B. Can be used to compare numeric or dates expressions.

NOW

Returns the current date and time (organization format), according to time offset defined for the cluster.

ADD HOURS

Adds the 'Number' of hours to the given 'DateTime'.

Example: ADDHOURS(NOW(), 3 )

ADD DAYS

Adds the 'Number' of days to the given 'Date'.

Example: ADDDAYS(NOW(), [Estimated Days to Refuel Tank 1] )

REPORT START

Returns the report's start date formatted as a date in the organization format.

REPORT END

Returns the report's end date formatted as a date in the organization format.

TO NUMBER

Returns the result as a number.

Example: TONUMBER("100")

TO TEXT

Returns the result as text.

Example: TOTEXT(100)

TO DATE

Converts input to a date result.

Example: TODATE(2024, 01, 01, 00, 00, 00)

TO HOURS

Converts a time span object to a numeric value which presents the number of hours.

Example: TOHOURS([EndTime] - [StartTime]) = "01.01:00:00" returns 25

TO DAYS

Converts a time span object to a numeric value which presents the number of days.

Example: TODAYS([EndTime]-[StartTime]= "1.12:00:00" returns 1.5