**the thread in the Autodesk AutoCAD**that was the basis for

^{®}Architecture Discussion Group**my previous blog article post on occupant load calculations**, Ted Evans pointed out that if you add a total to the occupant load column, the sum may not reflect the total of the displayed values. He is correct, if the displayed values have a sufficient number of cases where small fractional amounts were rounded up. Because any fractional amount is being rounded up in this case, there is no opportunity for round ups to be offset by round downs, making the fact that ACA uses the unformatted values when calculating the total even more apparent than in a situation where rounding is done to "nearest".

My reply today explained the reason why the total was not the same as the sum of the displayed numbers, and I indicated that in order for the total to be correct, the rounding should be done within the formula property, rather than by the Property Data Format. [For other options, see

**this blog article**, which includes several means of achieving real number rounding and getting correct column totals.]

By placing the results of each branch of the second If statement in a variable [occs] instead of making it the RETURN value, I was able to then process the value in variable occs. If occs is not a whole number (that is, if subtracting the integer portion of occs from itself does not result in a value of zero), the value of occs is reset to the integer portion of occs plus one. Otherwise, occs is a whole number, and rounding up is not necessary. The revised formula is shown below; a sample file was included in my reply in the Discussion Group.

```
occLoad = [SpaceStylesCalcs:Occupant_Load]
If occLoad = 0 Then
doCalc = 0
occLoad = 1
Else
doCalc = 1
End If
If doCalc = 1 Then
occs = [SpaceStyles:BaseArea] / occLoad
Else
occs = 0
End If
If occs - Int (occs) <> 0 Then
occs = Int (occs) + 1
End If
RESULT = occs
```