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

A TimeSeries is a series of points consisting of dates and values, associated with an entity, and stored in the Quintessence database along with other

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 and a range of data as input. Typically, a data feed would take

The Reportasync() function returns the output from a Quintessence report. The function provides the required parameter values as set up in the report configuration. Reportasync()

ExecuteScheduleAsync() works the same way as the ExecuteSchedule() function but calculates in the background (asynchronously from third party applications). This is useful for longer Schedules,

Schedules are automated workflows that perform tasks on behalf of a user. They can be run from the Quintessence application but also initiated from a

The audit log contains data pertaining to the usage which is channeled through Quintessence by users. The auditlog() function retrieves the records and associated information

The Span() function arranges multiple blocks of data into a single block of data and is often used to create reports consisting of multiple parts.

The Quintessence utility functions are available in both the Quintessence Excel® Addin and Quintessence Application. These functions perform useful manipulations on data. AlignToAxes ArrayToString Colouring

The XmlToArray() function converts a block of Xml formatted data to an Array. Syntax XmlToArray (Xml Input, Xml Mapping) Xml Input Raw Xml data used

The WebRequest() function retrieves data from a URL. Syntax WebRequest() Note: Input parameters can consist of Quintessence functions. This includes functions that return ranges in

The Unique() function returns the distinct rows in a range, in the order in which they occur. Syntax Unique (Range) Range The range of cells

The TypeCast() function takes a range as input and casts the columns or rows of that range according to a list of data types. The

The TransposeArray() function returns the transpose of a range (vertical columns are returned as horizontal rows or vice versa). Related functions: ArrayToString, StringToArray, SubstituteArray Syntax

The Transform() function takes a range of information and performs calculations on that information. In its simplest form, Transform() can be used to reorder columns