SILog map styles: Skillnad mellan sidversioner

Från DataPolarna
Hoppa till navigering Hoppa till sök
Rad 57: Rad 57:


== ROUND ==
== ROUND ==
Round a value to specified number of digits
'''Example'''
<pre>
ROUND(123.456, 2)
</pre>
will return 123.46
== SWITCH ==
== SWITCH ==

Versionen från 22 oktober 2025 kl. 14.56

Conditions

TODO: Add info

Functions

ANYOF

TODO: Add info

COALESCE

Use the first value that isn't null.

Example

COALESCE(product.name, storageArea.name)

Will show the name of the storage area if there isn't any product in the storage area.

IF

Match a single condition

Example

IF(storageArea.status = storageAreaStatus.empty, "Empty", "Not empty")

will return Empty for storage area with status empty

IFS

MAX

Returns the MAX value of two or more values

Example

MAX(1, 3, 2)

will return 3

MIN

Returns the MIN value of two or more values

Example

MAX(42, 1, 100)

will return 1

NOT

Match a false condition.

Example

IF(NOT(storageArea.status = storageAreaStatus.empty), "Not empty", "Empty")

Will return Not empty for any storage that doesn't have status empty

ROUND

Round a value to specified number of digits

Example

ROUND(123.456, 2)

will return 123.46

SWITCH