• COUNT()
• COUNTPATTERN()
• COUNTNZ()
• DATE()
• DAY()
• DAYS()
• DIFF()
• FIRSTNZ()
• INVERTER_ERROR()
• INVERTER_STATUS()
• LASTCHANGE()
• LASTNZ()
• MAX()
• MAXTIME()
• MD()
• MIN()
• MINUTES()
• ROUND()
• SUM()
• SUMACTIVE()
• TOTAL()
• VALUE()

Standard operators can be used in all formulas, such as +, -, *, /, <, >, ⇐, >= ( and ). IIF is possibler for expressions: <, ⇐, >, >=

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.

This would add the two Watt values of two inverters together and convert to kWh:

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'