topic Re: Rounding Totals in Revit Schedules in Revit Architecture Forum

Rounding Totals in Revit Schedules

Anonymous — Thu, 14 Feb 2019 20:19:39 GMT

I would like to only round a schedule total since I need to retain real values for every instance except the final sum (in this case let's say parking spaces since you cannot have a fractional space but still need a running list of those fractional spaces to obtain an accurate sum).

Re: Rounding Totals in Revit Schedules

barthbradley — Thu, 14 Feb 2019 22:38:23 GMT

Re: Rounding Totals in Revit Schedules

barthbradley — Thu, 14 Feb 2019 22:37:58 GMT

Huh? Are you saying that you want the itemized totals to be precise, but the grand total to be rounded? It's a little confusing because your mark ups are shown in 2 different columns.

Re: Rounding Totals in Revit Schedules

SteveKStafford — Thu, 14 Feb 2019 23:52:09 GMT

Rounding doesn't permit that distinction. If you need to see the calculated result, don't show the total for that column. Work out the logic in another column to round up/down to provide a value that can be summed to show the correct/desired total value.

Parking spaces can't be a fraction so usually municipal code requires rounding up or down or provides a way to adjust the total requirements by a certain volume. That is far too subtle to work in a single column. You'll probably best served showing the calculated result but then write up a summary that demonstrates how you reached your code compliance. The summary could sit next to the schedule(s) you provide.

Re: Rounding Totals in Revit Schedules

Avaris. — Fri, 15 Feb 2019 08:36:08 GMT

No matter how you will solve it:

ROUND(x)

ROUNDDOWN(x)

ROUNDUP(x)

Are all valid commands in Revit formulas/calculated values.

Re: Rounding Totals in Revit Schedules

Anonymous — Sat, 16 Feb 2019 02:59:13 GMT

Can you not apply a formula to a single cell in Revit?