Jump to content

Translations:BIM Report/32/en

From FreeCAD Documentation

Now, let's add a second statement to calculate the total area.

  1. In the overview, click Add Statement again to create a second statement.
  2. With this new statement selected, click Edit Selected.
  3. Set the Description to Total Area.
  4. In the SQL Query editor, enter this aggregation query:
    SELECT 'Total Usable Area', SUM(Area) FROM document WHERE IfcType = 'Space'
    
  5. Under Display Options, uncheck Include Column Names (since our first column is a custom label) and check Print Results in Bold for emphasis.
  6. 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.