Differences

This shows you the differences between two versions of the page.

--- wiki:widget_functions [2018/05/22 08:02]
admin
+++ wiki:widget_functions [2021/10/25 05:45] (current)
admin
@@ Line 3: / Line 3: @@
   * [[wiki:COUNT|COUNT()]]
+  * [[wiki:COUNTPATTERN|COUNTPATTERN()]]
+  * [[wiki:COUNTNZ|COUNTNZ()]]
+  * [[wiki:DATE|DATE()]]
+  * [[wiki:DAY|DAY()]]
+  * [[wiki:DAYS|DAYS()]]
   * [[wiki:DIFF|DIFF()]]
+  * [[wiki:FIRSTNZ|FIRSTNZ()]]
+  * [[wiki:INVERTER_ERROR|INVERTER_ERROR()]]
+  * [[wiki:INVERTER_STATUS|INVERTER_STATUS()]]
   * [[wiki:LASTCHANGE|LASTCHANGE()]]
-  * [[wiki:LASTNZ|LASTNZ]]
+  * [[wiki:LASTNZ|LASTNZ()]]
   * [[wiki:MAX|MAX()]]
+  * [[wiki:MAXTIME|MAXTIME()]]
   * [[wiki:MD|MD()]]
   * [[wiki:MIN|MIN()]]
+  * [[wiki:MINUTES|MINUTES()]]
   * [[wiki:ROUND|ROUND()]]
   * [[wiki:SUM|SUM()]]
@@ Line 18: / Line 28: @@
 ===== Operators =====
-Standard operators can be used in all formulas, such as +, -, *, /, ( and ).
+Standard operators can be used in all formulas, such as +, -, *, /, <, >, <=, >= ( and ).  IIF is possibler for expressions: <, <=, >, >=
+===== Conditionals =====
+In order to test for a condition, you can use the syntax:
+''VALUE('variable',0) > 5 ? 1 : 0''
+The comparison uses the IIF syntax -  so if compared value > 5 the output would be 1 and otherwise (:) 0.
 ===== Examples =====
@@ Line 24: / Line 40: @@
 ''VALUE('delta0w_ac') / 1000 + VALUE('delta1w_ac') / 1000''
+This example will output 'High' or 'Low' based on the threshold value.
+''VALUE('myvar')>5?'High':'Low' ''

Wattmon EMS