Total in schedule not equal to sum of rounded values in table

Issue

You made a schedule for room areas that displays the total of the areas in the schedule, and you noticed that the total is slightly different from the sum of the values.

Solution

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:

1. In the schedule, click the Element Properties button.
2. In the Element Properties dialog box, click the Edit button for Fields.
3. In the Schedule Properties dialog box, click the Calculated Value button.
4. In the Calculated Value dialog box, enter a name (for example, "AreaRoundInteger").
5. Change the Type to Integer.
6. 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.
7. Click OK to close the Calculated Value dialog box.
8. Click the Calculated Value button.
9. In the Calculated Value dialog box, enter a name (for example, "AreaRound").
10. Change the Type to Number.
11. Enter the following formula: AreaRoundInteger / 100
12. Click OK to close the Calculated Value dialog box.
13. In the Schedule Properties dialog box, click the Formatting tab.
14. Select the AreaRoundInteger field and then click the Hidden Field option.
15. Select the AreaRound field and then click the Calculate Totals option.
16. Click the Field Format button and set the rounding to 2 decimal places.
17. Click OK to close each dialog box.