jColumnDef()

Estimated reading time: 4 minutes

Function Summary

The jColumnDef function defines a column based on one or more parameters. Each parameter represents a segment. The segments can be set to filter the data that this column represents. Typically this function is used with a Data Pull function for a financial report.

The jColumnDef function utilizes a DataPortal to interact with the segments. This DataPortal is specifically setup for the particular needs of the company using Interject. The segments are thus customizable. For most companies, the Interject FinCube DataPortal will suffice for their reporting needs.

For an example of this function, see Lab Create: Financial Variable .

Function Arguments

The parameters and segments listed below are some examples of the FinCube DataPortal. Actual parameters will vary depending on what DataPortal is being used. For more information about these parameters, see FinCube.

Type String/Range
Constraints Max 255 char or single cell
If Blank Does not filter data

Type String/Range
Constraints Max 255 char or single cell
If Blank Does not filter data

Type String/Range
Constraints Max 255 char or single cell
If Blank Does not filter data

Type String/Range
Constraints Max 255 char or single cell
If Blank Does not filter data

Type Custom
Constraints Custom
If Blank Custom

Type String
Constraints "MTD", "QTD", "YTD", "QTR"
If Blank "MTD"

Excel Formula Bar Example

=jColumnDef(Actual,11,2001)

Function Composition

Argument Name Example Mapping Explanation
Function Name jColumnDef The name of this function.
Source "Actual" The data for this column will be from "Actual".
Period 11 The data for this column will be from period 11.
Year 2001 The data for this column will be from year 2001.