TrainEstimated reading time: 9 minutes
Interject for Financials Quick Reference
Important Interject Hotkeys
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.
=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
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.