Problems with the "roundup" formula

[Anonymous]

I need the result of the item "QTD S/ PERDAS" to be rounded up in the item "QTD TOTAL", that is, if the result was 0.47 I need it to be 1. However, when I use the formula "roundup" by if several family elements are modeled it will round the results for each element and then add them together, instead of adding all the elements and then rounding up, resulting in a value well above what I needed.

[barthbradley]

Sounds like you are saying that you want the roundup column to only roundup certain row values, but not others. If so, you might be able to get there with an conditional argument. e.g. =if("this condition is true", roundup(value), value).

Revit Formulas for "everyday" usage (revitforum.org)

[Anonymous]

I will give an example, I have several modeled walls, so I would like the program to add and round the final sum of the area of the walls, however, it rounds the area of each wall and then adds, resulting in a value well above the that I desire.