RoundUp Grand total in schedule
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
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...