jColumnDef()

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.

Source (Segment12)
The source of the data (e.g. "Actual", "Budget", "Projection", etc.).

Period (Segment9)
The period of the data (e.g. 1-12 for a month of the year, 1-4 for a quarter). Also accepts YYYY-MM format.

Year (Segment10)
The year of the data. Also accepts YYYY-MM format.

Version (Segment11)
The version of the data.

Customizable (Segment1-8)
Configurable segment.

BalanceType
A string indicating the balance type.

Excel Formula Bar Example

=jColumnDef(Actual,11,2001)

Function Composition