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: 

Roundup total, not itemized

7 ANTWORTEN 7
GELÖST
Antworten
Nachricht 1 von 8
jagostinho74
775 Aufrufe, 7 Antworten

Roundup total, not itemized

Hello,

 

How to get a roundup column which picks up on the calculated total displayed and not rounding up each area individually first and them add them all up.

 

In the example below, I want to be able to roundup the 8.1m2 into 9 m2, not rounding up each 4.1m2 into 5m2 and show 10m2

 

Thank you

J

 

Formula.pngAreaRoundUpItemized.pngAreaRoundUpGrouped.png

Assistant BIM/CAD Manager

Manchester, UK


7 ANTWORTEN 7
Nachricht 2 von 8
Kimtaurus
als Antwort auf: jagostinho74

Revit always calculates using the original individual values.

So it's not using the total of the rooms to calculate with, but the values per instance.

 

I doubt that what you want can be achieve in Revit, at least not automatically, maybe with Dynamo.

Or export your schedule to Excel.

_____________________________________________________________________________
Please use "Accept as Solution" and give kudos as appropriate to further enhance these forums. Thank you!
Nachricht 3 von 8
jagostinho74
als Antwort auf: Kimtaurus

Thank you. Was trying to check if there was a workaround for this.

Assistant BIM/CAD Manager

Manchester, UK


Nachricht 4 von 8
ToanDN
als Antwort auf: jagostinho74

It's doable.  See attached.

 

Capture.PNG

Nachricht 5 von 8
jagostinho74
als Antwort auf: ToanDN

@ToanDN. Thanks.

That schedule is itemized.

How about for grouped values? See my images above.

Assistant BIM/CAD Manager

Manchester, UK


Nachricht 6 von 8
ToanDN
als Antwort auf: jagostinho74

Still works.

 

Capture.PNG

Nachricht 7 von 8
jagostinho74
als Antwort auf: ToanDN

I need it to roundup in a way so that if total grouped area = 8.1m2 it rounds to 9.0m2

 

Assistant BIM/CAD Manager

Manchester, UK


Nachricht 8 von 8
jagostinho74
als Antwort auf: ToanDN

Roundups.png

Assistant BIM/CAD Manager

Manchester, UK


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