Excel-like formula editor
Last updated
Last updated
Inforiver provides a no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers. The formula editor provides syntax, examples and features such as autocomplete, multi-line support and more to help users create, and troubleshoot formulas.
(a) Conditional statements - IF, IFNA and SWITCH
(b) Logical functions - AND, NOT, OR, IN, ISEMPTY etc.
(c) Math functions - ABS, AVERAGE, AVERAGEIF, COUNT, SUM, FILTER etc.
(d) Text formatting functions - CONCATENATE, LEFT, RIGHT, MID, CLEAN, UPPER, LOWER etc.
(e) Date functions - DAY, MONTH, DATEADD, DATEDIFF, FROMEXCELDATE, TOEXCELDATE etc.
(f) Statistical functions - MEDIAN, MODE, QUARTILE, QUARTILEEXC, STDEV, STDEVP etc.
(g) Sort functions – SORT, SORTDESC
(h) Identifiers - COLUMNS, DESCENDANTS, HAS, HAS_ALL, RELATIVE etc.
Related resources
Feature highlightsVisual calculations in Power BI
User guideList of formulas and functions
Blog