I've tried the method mentioned here: https://forums.autodesk.com/t5/revit-architecture-forum/round-up-calculated-total-of-revit-schedule-... but this doesn't work for me. Post 17 mentions "I still created a (result%) based off of the Result column only instead of it being <calculated total> I selected <Type>." but I do not have the option to choose <Type> there.
All I really need is a way to show the Grand Totals but rounded up. This is for an ordering form for certain tiles and only whole tiles can be ordered. So when the Grand Total comes down to a quarter tile (so ...,25) you'd still need to order a whole tile.
EDIT:
I've added a Calculated Parameter to my schedule that does if(and(Total - Total Int. > 0, Total - Total Int. < 0.5), Total Int. + 1, Total Int.) but that does nothing. Total Int. calculates the same thing as Total except it's set to 0 decimal places in Field Format...
could you add screen shots for what you have and what you want
Ahmed Muharram, B.Sc, AEE, ACI, ACP
BIM Manager
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.
Pardon the delay, the project was temporarily put on hold. Anyways, here's the screen shot:
Schedule of totals
EDIT:
The number in the blue square is a Calculated Parameter from the Grand Totals of the other three values:
Total Amount Full Cassettes + (Total Amount Half Cassettes / 2) + (Total Amount Quarter Cassettes / 4)When I set this Calculated Parameter to Integer it'll round down to 75 but I need this number to be rounded upwards to 76. If I set RoundUp(<Calculated Parameter>) it will roundup all the values in the rows below and then give me the Grand Total of those roundedup numbers which is not what I want.
All these values are read from shared parameters and everything works as intended except for the Calculated Parameter at the very end.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.