Cross-Sheet Referencing in Report Styler

Overview

You can create complex reports with Qvinci. There may be times when you would like to enter data in different tabs and reference those tabs in your reporting results.

Cross-referencing is done in the same worksheet or in different worksheets in the same file.

Cross-Sheet Referencing in Report Styler

To accomplish this, a cell is named using a column using letters and a row using numbers. 

When a multi-tab report is created in the Report Styler, it is oftentimes necessary to use cross-sheet referencing. The format for cross-sheet referencing is similar to that of Excel.

You will reference the sheet name, followed by the column and row, or use a range of columns and rows.

If you're using a data tab that you do not want to see in the completed report, name that tab with # in front to keep it hidden and also to not print.

Using the BI-KPI SC Mutli-Entity - FYTD v PFYD +% (S) as an example, we can see multiple hidden data tabs at the bottom.

In this report, we reference cells in these data tabs to produce the results we want to see. 

Cell Formula: ='Sheet Name'!Cell 

This would be used if you wanted to reference a single cell value in your report.

Example: '#Calculations-data'!L36

Range Formula: ='Sheet Name'!Cell:Cell

This would be used if you wanted to include a range of cell values in your report.

Example: ='#system-top20-data'!A2:H32

Have Questions?
We're More Than Happy to Help

Schedule a call with Customer Success below, email us at support@qvinci.com or call us at 1-512-637-7337 Ext. 1 Available M-F, 7:30am-6:30pm CT and it is always FREE!

Schedule an Appointment with Customer Success