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.
You can use the formula menu to quickly locate the formula you are looking for. Click the fx button to open the formula menu.
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.
Refer to the below sections for a detailed list of functions, operators, and identifiers that can be used for calculations.
