Translations:BIM Report/32/en
Appearance
Now, let's add a second statement to calculate the total area.
- In the overview, click
Add Statement again to create a second statement.
- With this new statement selected, click
Edit Selected.
- Set the Description to
Total Area. - In the SQL Query editor, enter this aggregation query:
SELECT 'Total Usable Area', SUM(Area) FROM document WHERE IfcType = 'Space'
- Under Display Options, uncheck Include Column Names (since our first column is a custom label) and check Print Results in Bold for emphasis.
- Click
Save. You now have a two-statement report. Click the main OK button at the bottom of the Task Panel to execute it. The associated spreadsheet will open automatically with the formatted results.