Roundup total, not itemized

Roundup total, not itemized

jagostinho74
Collaborator Collaborator
910 Views
7 Replies
Message 1 of 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 Likes
Accepted solutions (1)
911 Views
7 Replies
Replies (7)
Message 2 of 8

Kimtaurus
Advisor
Advisor
Accepted solution

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 Likes
Message 3 of 8

jagostinho74
Collaborator
Collaborator

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

Assistant BIM/CAD Manager

Manchester, UK


0 Likes
Message 4 of 8

ToanDN
Consultant
Consultant

It's doable.  See attached.

 

Capture.PNG

0 Likes
Message 5 of 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 Likes
Message 6 of 8

ToanDN
Consultant
Consultant

Still works.

 

Capture.PNG

0 Likes
Message 7 of 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 Likes
Message 8 of 8

jagostinho74
Collaborator
Collaborator

Roundups.png

Assistant BIM/CAD Manager

Manchester, UK


0 Likes