I need help rounding up the Calculated Total of a cell within a column of a Revit Schedule. As an example, I have a schedule with (4) parameters: "Count", "Value","Denom","Result". Count being the number of elements, Value being some value associated to the element, Denom being the Denominator Value is to be divided by, and Result being the Result. All columns shown in grey have the "Calculate Totals checked" and thus show the combined total for each type.
For column "Result" it is a calculated value as a "Number" with a formula "Value/Denom" at a Field Format of 2 decimal places.
My issue is rounding up these values to the nearest whole number. I cannot simply change the "Result" calculated value to "roundup(Value/Denom)" as it would result incorrectly or even null
for example, the first row of Result of type count 5 is really the sum of (3/24 = 0.13) 5 times or 0.65.
0.13
0.13
0.13
0.13
0.13
if I used the roundup function it would result in, resulting in a total of 5.
1
1
1
1
1
The desired outcome being the next whole number of 0.65 = 1.
Any idea how to go about this? Thank you.
Solved! Go to Solution.
Thank you for replying. But I do not See Type in your Schedule. I am trying to apply your example to my chart, but without understanding what is referring to or what type of parameter it is and the value, I can not follow your steps.
Here is a screenshot of my case, hopefully you can give me a hand
Thank you for your help. I tried to apply your formula and it worked somehow, but not in all the results. Please let me know your findings.
The standard programming technique for rounding a decimal value up to the next integer is to add 0.5 to the value, then round off to the nearest integer.
0.1 + 0.5 = 0.6 rounded off = 1
0.9 + 0.5 = 1.4 rounded off = 1
Ok, So I added your "parking reqd' calc" as a sorting category.(this is what allows you to use it in the result %.)
I then filtered your result % by that category.
and I believe that it works correctly now. Hope this helps
I've done this before in 2019 when I used floor plans now trying to do it in 2020 with area plans and I don't get "name" in the "by:" part of the "Result % calculated value just grand total. The schedule isn't rounding up. Appreciate any help thanks
That worked but now I noticed an area that's 1449.1 divided by 7 rounding to 208 instead of 207 when the area appears as 1449 in the schedule - can I force the area to be counted rounded up?
Can't find what you're looking for? Ask the community or share your knowledge.