Train

Estimated reading time: 9 minutes

Interject for Financials Quick Reference

Important Interject Hotkeys

To Know

Ctrl+Shift+J: Pulls data into your report after selecting parameters from the dropdowns in the parameter section.

Ctrl+Shift+K: Drills through a selected value to a more detailed report (drills are available only in predefined cells).

Ctrl+Shift+U: Saves data or configurations back to a database.

Ctrl+Shift+L: Opens the report library, where you can access your organization’s published reports.

Important Formulas

To Know

=JCombineSmart(): Concatenates, orders, and removes duplicates of selected range to enter validation definitions or detail row definitions when building financials reports.

=EDate(): Use to set the period of interest as an absolute reference to the fiscal period filter when building financial reports. Pass “,-[chosen cell]” when building subsequent columns from the period of interest.

Important Actions on the Interject Ribbon Menu

To Know

1: Use to access and share report in your organization.

2: Use to pull data into the report after selecting parameters from the dropdowns in the parameter fields. You may also use the button in the report paramter area.

3: Use to save data or configurations back to a database.

4: Use to Drill through data into more detailed reports. You can go back one drill by pressing the Return From Drill button to the right of the drill button.

Open report link button