|Page tools: Print Page Print All|
The validation table is an Excel spreadsheet containing data for checking purposes. It is important to check totals from tables created against the validation table to ensure you have extracted correct data. This is due to overcounting that will occur in the table if you include all possible categories for some classifications. For example, for Type of Building, you must select the categories you require, and include the classification in the table. If you do not do this, records will be counted more than once because sub-totals and totals are included in this classification. Even if you do not require Type of Building in your table, overcounting will occur unless you select only the total category and drag this into the table. Note also that Reference Quarter must be brought into the table or the table will show the total for all quarters. Best practice is to make sure all fields are selected and put into the table.
For definitions of which categories comprise the various sub-totals and totals for Type of Building, and how to calculate Conversions etc. from the data cube, see the attached document 'Formula.pdf'.