Formula syntax

Inforiver's Excel-like formula engine supports a wide range of functions (logical, boolean, math functions, and more). The formula editor provides syntax, examples, and features such as autocomplete, multi-line support, and more to help users create, and troubleshoot formulas.

Formula menu

You can use the formula menu to quickly locate the formula you are looking for. Click the fx button to open the formula menu.

Formula menu

Replicating formulas

Variance analysis or calculating depreciation or interest can involve using the same formula multiple times. An update to the formula would require opening and editing each visual column individually. You can use the Copy to Column option to replicate the formula across all columns. When you click the Copy to column icon, you will be able to select the visual columns across which the formula should be replicated.

Copy to column option for visual columns

Refer to the below sections for a detailed list of functions, operators, and identifiers that can be used for calculations.

• Conditional Statements

• Logical Functions

• Math Functions

• Text Formatting Functions

• Date functions

• Time intelligence functions

• Identifiers

• Other Operators

• Scripting Functions

• Miscellaneous Functions