<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Schedules formula for rounding up in Revit MEP Forum</title>
    <link>https://forums.autodesk.com/t5/revit-mep-forum/schedules-formula-for-rounding-up/m-p/5725156#M74876</link>
    <description>&lt;P&gt;I wish I understood what you are trying to do better because I could do some some algorithm ninjutsu on it because thats what you are going to need. The problem you are facing is not that roundup function isn't working. Its that it is but in a way that you didnt expect. Revit can't do equations on calculated total values like you are expecting. For example you see that your value Quantity of Cables total is 51 and you are dividing that by 48 to get 1.0625 Right?... Wrong. What is really happening is that revit is taking EACH of your Quantity of Cables values and dividing it by 48, then it is summing the total because you checked the calculate totals box. In this case the end value is the same, but your assumption for how it got there is wrong. The order of operations is very important to understand because when we look at what is happening for the Patch Panel Calculated value, is that you are rounding EACH of the values, from .0625 or whatever to 1 and since you didnt check the calculate totals value it displays 1. So it looks to you like you are using roundup to go from 1.0625 to 1 but you didnt understand the order of operations. If you are clever, you should be able to do what you need inside the family, but you can't do it in the schedule like that. Hope that helps.&lt;/P&gt;</description>
    <pubDate>Fri, 17 Jul 2015 16:14:30 GMT</pubDate>
    <dc:creator>revitworkbench</dc:creator>
    <dc:date>2015-07-17T16:14:30Z</dc:date>
  </channel>
</rss>

