Refers to a specific segment of the economy that includes companies or organizations engaged in similar business activities. Sectors are used to categorize and analyze
Quintessence Functions
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,
The SubArray() function is used to create a new array from a partial area of an existing array. Syntax SubArray (Data Range, Rows, Columns) Data
The GroupBy() function groups a range of data into sets and calculates values per set using aggregation functions, for example, SUM, AVERAGE, COUNT etc. GroupBy()
The Join() function combines rows from two ranges of data into a single range. This function works in a similar way to the join functionality
The FilterData() function is used to filter and output a range of information according to specified criteria. Syntax FilterData (Range, Criteria, Columns) Range The range
The IsDefined() function determines whether an input parameter has a value assigned to it or not. Related functions: IsDate, IsElement, IsNull Syntax IsDefined (Element) Element
The IsElement() function assesses whether an array contains an element. Related functions: IsDate, IsDefined, IsNull Syntax IsElement (Element,Array) Element Any string or numeric value Array
Introduction The Layouts feature in Formatted Reports allows you to combine multiple formatted reports into a single, cohesive report. This feature offers flexibility by enabling
Introduction User access control in Formatted Reports allows you to lock or unlock specific cells in a report, providing structured access to data. This ensures
Introduction In Formatted Reports, formulas allow for dynamic calculations directly within the report. Using IronPython, you can set formulas in cells either by referencing relative
Introduction Data validation in Formatted Reports ensures that users enter data accurately and consistently by enforcing specific rules and formats. Validation can be applied to
Introduction Callbacks in Formatted Reports enable automated data transfer and task initiation by passing a table of data to a datafeed or kicking off a
Introduction In Formatted Reports, Formatting Options are essential for transforming raw data into a polished, functional Excel report. With formatting tools, you can control data
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
Refers to the ownership of a financial asset, such as stocks, bonds, or other securities. When an investor holds a financial asset, it means they
View More