Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Rounding Totals in Revit Schedules

5 ANTWORTEN 5
Antworten
Nachricht 1 von 6
Anonymous
1155 Aufrufe, 5 Antworten

Rounding Totals in Revit Schedules

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).

revit rounding.JPG

5 ANTWORTEN 5
Nachricht 2 von 6
barthbradley
als Antwort auf: Anonymous

 

.

Nachricht 3 von 6
barthbradley
als Antwort auf: Anonymous

 

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. 

Nachricht 4 von 6
SteveKStafford
als Antwort auf: Anonymous

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.


Steve Stafford
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
EESignature

Nachricht 5 von 6
Avaris.
als Antwort auf: SteveKStafford

No matter how you will solve it:

ROUND(x) 

ROUNDDOWN(x) 

ROUNDUP(x) 

 

Are all valid commands in Revit formulas/calculated values.

Nachricht 6 von 6
Anonymous
als Antwort auf: barthbradley

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

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report