By Autodesk Revit default, the total is different from the sum because the total is calculated using the exact value of the areas and not the rounded values shown in the schedule.
If you would like the total to be based on the rounded values instead, follow these steps:
- In the schedule view, open the Instance Properties palette. If you need to open the Instance Properties palette, active View tab, from the Windows panel; click the User Interface dropdown and check Properties check box.
- In the Instance Properties palette, click the Edit button for Fields.
- In the Schedule Properties dialog box, click the Calculated Value button.
- In the Calculated Value dialog box, enter a name (for example, "AreaRoundInteger").
- Change the Type to Integer.
- Enter the following formula: Area / 1 * 100
Note: Dividing by 1 prevents unit errors.
Note: The factor depends of the decimal places that are used. In this example, 100 is used for 2 decimal places. - Click OK to close the Calculated Value dialog box.
- Click the Calculated Value button again.
- In the Calculated Value dialog box, enter a name "AreaRound".
- Change the Type to Number.
- Enter the following formula: AreaRoundInteger / 100
- Click OK to close the Calculated Value dialog box.
- Select the Residential_Area (for this example) field and then click the Edit button
- Revise to the following formula: if(Residential, AreaRound *1, 0)
- In the Schedule Properties dialog box, click the Formatting tab.
- Select the AreaRoundInteger field and AreaRound field, and then click the Hidden Field option.
- Select the Residential field and then click the Calculate Totals option.
- Click the Field Format button and set the rounding to 2 decimal places.
- Click OK to close each dialog box. You will get the correct result as below:-
