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.
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
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
The UploadDataAsync() function uploads data to Quintessence using a configured data feed and a range of data as input. Typically, a data feed would take
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
View More