The platform's calculation engine executes Process Logic workbooks server-side. It supports a defined set of Excel functions, but not every Excel function is available, and some functions may behave differently from their desktop Excel equivalents.
Only use functions that have been verified to work with the calculation engine. Functions outside the supported set may produce unexpected results or fail silently.
Supported categories
The following categories of Excel functions are supported:
Database functions
Date and time functions
Financial functions
Information functions
Logical functions
Lookup and reference functions
Mathematical functions
Statistical functions
Text functions
These cover the vast majority of what is needed for data processing, calculation logic, and text manipulation in Process workbooks.
Array functions
Array functions are not recommended. Their behaviour and performance can vary between versions of the calculation engine, leading to inconsistent results. Where possible, design workbook logic using standard functions rather than array formulas.
Differences from desktop Excel
The calculation engine may interpret some functions differently from desktop Excel. This can affect calculation results, how certain data types are handled, or performance. Always test workbook logic against the platform's calculation engine — results that look correct in desktop Excel may differ when executed server-side.
In particular, verify date handling, number precision, and any functions that depend on locale or system settings. See Process Logic Workbook for guidance on formatting requirements for output data.