Excel Function IndexEstimated reading time: 7 minutes
Interject Function Index
INTERJECT provides features by leveraging spreadsheet formulas that are familiar to many users. These formulas can be used to direct data into a spreadsheet, creating practical and adaptable reports. By adding report drills and navigation through additional spreadsheet formulas, these reports become a comprehensive reporting solution.
Data Functions are focused on getting specific data to the report in the right way and placed inside the spreadsheet. There are a variety of functions and options therein to give flexibility in what data is displayed.
|ReportDrill()||Drilling down on data and Navigating between reports|
|ReportFixed()||Pulling in data to a predetermined fixed point.|
|ReportLookup()||Insert a specific data value into a cell based on certain criteria.|
|ReportMacro||Call VBA macros on Save, Pull, Clear, or Run events.|
|ReportRange()||Inserts data into a single range of a spreadsheet|
|ReportRun()||Execute Report functions in other sheets.|
|ReportSave()||Save data on the sheet back to the database.|
|ReportVariable()||Insert data into rows that include multiple ranges or sections|
Formatting Functions are focused on the report itself and does not impact or direct data in the report. These functions can improve the speed and presentation of which data can be understood, manipulated and seen in the report. Once formatting functions are fully understood, reports can be dissected, analysed, and assessed at a much more rapid pace with a very low amount of impact on report run times.
|JFocus()||Sets the excel focus (active cell selection) upon a freeze panes action|
|JFreezePanes()||Used with the QuickTools option for freeze/unfreeze panes.|
|ReportCalc()||Executes a calculation on a worksheet or workbook.|
|ReportDefaults()||Utilized to capture and send values from one cell(s) to another.|
|ReportHideRowOrColumn()||Hides rows and columns on report events|
|ReportMerge()||Merge multiple Excel reports into one based on jMergePoints()|
Helper Functions are often embedded into other parent functions (listed above) to be leveraged into more specific and accurate functions or enhance their capabilities. Some can also be used in stand-alone fashion to add functionality to the page.
|jBinder()||Assists the Binder feature mark worksheets|
|jColumnDef()||Assists financial reports using the FinCube DataPortal to specify segment filters for each amount column.|
|jCombineIf()||Uses a conditional statement to determine which values should be included into a single concatenated string.|
|jCombine()||Concatenate the values of cells while simultaneously skipping any empty cell.|
|jDataPortal()||Helpful function for developers to further leverage DataPortals.|
|jMergePoint()||Acts as a reference point for ReportMerge .|
|jRangeTag()||Used to label or tag a range or a single cell with a custom name.|
|jWorkbookProperty()||Provides context and information about a workbook in a report.|
|Pair()||Used with a variety of report functions to specify a from value or range to a target location or range.|
|PairGroup()||Used to string multiple Pair() functions together into one comma delimited string|
|Param()||Used to help select one or multiple parameters for each of your report formulas|
Data Cell Functions
Data Cells are focused on a single formula which can be placed anywhere in the spreadsheet and can ask for any financial number or summary from it. Once this single formula approach is understood, there is no limit to the combinations that can be created. This is typically an easier method to start writing custom reports. However, given their flexibility the report run times can take more than just a few seconds to complete, sometimes up to 5 minutes. Larger reports, such as one with 70,000 formulas, can take up to 10 minutes to complete. Fortunately, users may continue working with a spreadsheet while waiting for Data Cell reports to finish calculating.
|jAcct()||Specifies filters for up to six segments of a Chart of Accounts|
|jCell/jCellN()||Retrieves data based on the provided parameters|
|jDesc()||Used to look up a context description based on a specific segment.|