Roundup total, not itemized

Roundup total, not itemized

jagostinho74
Collaborator Collaborator
916件の閲覧回数
7件の返信
メッセージ1/8

Roundup total, not itemized

jagostinho74
Collaborator
Collaborator

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


0 件のいいね
解決済み
917件の閲覧回数
7件の返信
返信 (7)
メッセージ2/8

Kimtaurus
Advisor
Advisor
解決済み

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!
0 件のいいね
メッセージ3/8

jagostinho74
Collaborator
Collaborator

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

Assistant BIM/CAD Manager

Manchester, UK


0 件のいいね
メッセージ4/8

ToanDN
Consultant
Consultant

It's doable.  See attached.

 

Capture.PNG

0 件のいいね
メッセージ5/8

jagostinho74
Collaborator
Collaborator

@ToanDN. Thanks.

That schedule is itemized.

How about for grouped values? See my images above.

Assistant BIM/CAD Manager

Manchester, UK


0 件のいいね
メッセージ6/8

ToanDN
Consultant
Consultant

Still works.

 

Capture.PNG

0 件のいいね
メッセージ7/8

jagostinho74
Collaborator
Collaborator

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


0 件のいいね
メッセージ8/8

jagostinho74
Collaborator
Collaborator

Roundups.png

Assistant BIM/CAD Manager

Manchester, UK


0 件のいいね