Excel Function Index

Estimated 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

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.

Forumula Description
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

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.

Formula Description
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

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.

Formula Description
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.

Formula Description
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.