Rounding up Total

[jason.harcourtE9D7U]

Hi All,

Trying to accurately cost timber lengths for picking and supply. have got as far as the attached but need to round the lengths up to 4800mm lengths for picking in the factory and the total cost to then calculate the rounded up qty not the exact qty.. Any suggestions? (see attached)

[barthbradley]

Are you talking about the grand totals?  

[jason.harcourtE9D7U]

the length qty. I want to round it up to the nearest length then have the total cost take that number for calculating the cost as we will be supplying full lengths without cutting them down

[barthbradley]

You could get there via a Calculated Parameter using Percentage. 

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-M...

https://knowledge.autodesk.com/support/revit-lt/learn-explore/caas/CloudHelp/cloudhelp/2016/ENU/Revi...

[jason.harcourtE9D7U]

thankyou but not sure how that works to be honest. ?

[barthbradley]

---

@jason.harcourtE9D7U wrote:

thankyou but not sure how that works to be honest. ?

---

I added some links for you. 

Basically, you need to create Calculated Parameters using formulas.  Do you follow?  

[jason.harcourtE9D7U]

yes just not sure how to do it

[mhiserZFHXS]

I don't have Revit open so you may need to adjust syntax.

Try something like:

roundup(Total Lengths/4800)*4800

Then for pricing:

(roundup(Total Lengths/4800)*4800) * Cost

If total length is already a calculated parameter, you'll need to replace that parameter with the equation used for total length, as you can't reference a calculated parameter with another calculated parameter (which AutoDesk should really address).

Edit: Apparently you can use calculated parameters in equations. Not sure if that's new or if I was having some other issue with it last time I tried to figure it out.

[jason.harcourtE9D7U]

i tried that but didnt work for some reason. have attached the file incase you can help further. Thankyou

[mhiserZFHXS]

Yea it's not working because of how Revit lets you use "Count", which is really unfortunate.

You could use Dynamo to do the math and then populate another parameter. That's the best I can think of now after playing with it, unless someone else can think of something.

[ToanDN]

To clarify, do you just want know how many 4.8 meter members you need to buy in total?

[jason.harcourtE9D7U]

Yes pretty much

[ToanDN · Accepted solution]

Edited file.

[jason.harcourtE9D7U]

ToanDN thats perfect. Thankyou so much