SILog map styles: Skillnad mellan sidversioner
Hoppa till navigering
Hoppa till sök
Peter (diskussion | bidrag) |
Peter (diskussion | bidrag) |
||
| 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