The Sparse() function, together with Excel’s implicit intersection operator (=@), allows the user to edit blank cells inside a returned result. When the function recalculates,

The ExportExcel() function takes a data block and exports it into an Excel workbook. The function can also append worksheets to existing Excel workbooks. This

The ExportCSV() function takes a data block and exports it into a CSV file. This function is only available in the Quintessence Language (for example,

Similar to CsvToArray, the ImportCsvText() function converts a block of CSV-formatted data into an array. However, this function also allows you to apply filter expressions

PivotView() is one of the view options for displaying data retrieved from the RelationshipData() and TimeSeries() functions. This view organises the requested data into rows

GlobalVariable() allows users to access variables configured by the administrator on a global level. These variables can be accessed from the Quintessence editor (from artifacts

Note: This is a legacy function and will be deprecated soon. Please use TimeSeries() instead.

Note: This is a legacy function and will be deprecated soon. Please use TimeSeries() instead.

Introduction Formatted Reports allow users to enhance basic data reports with advanced formatting, dynamic features, and user interaction options using IronPython. By adding formatting and

NPV stands for Net Present Value, and it is a financial metric used in capital budgeting and investment analysis. The Net Present Value represents the

The UpdateState() function is an Excel specific Quintessence function that returns a Boolean value indicating whether either the Upload Sheet or Upload Selected button was

TimeSeries is a sequence of data points, each consisting of a date and a value, associated with an entity and stored in the Quintessence database

JSON (JavaScript object notation) is a syntax for storing and exchanging data. Since the JSON format is text only, it can easily be sent to

The UploadDataAsync() function uploads data to Quintessence using a configured data feed. It processes the input range as is and bypasses any transformations. The async

ReportAsync() performs calculations in the background (asynchronously from Excel). This is useful for larger reports, allowing you to continue working in Excel while the report

ExecuteScheduleAsync() works the same way as the ExecuteSchedule() function, but runs in the background (asynchronously when called from third-party applications). This is useful for longer-running

Schedules are automated workflows that perform tasks on behalf of a user. They can be run directly from the Quintessence application or triggered programmatically using

The audit log captures data related to usage activity routed through Quintessence by users. The AuditLog() function retrieves records and relevant details for all requests