Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Conditional Formula to Round up Occupant Load if less than 1

1 ANTWORT 1
Antworten
Nachricht 1 von 2
meganAPYT4
100 Aufrufe, 1 Antwort

Conditional Formula to Round up Occupant Load if less than 1

Hi all,

 

Writing out an area schedule and want to round a calculated occupant load up to 1. i.e., 56 SF/ 300 SF Gross = 0.19, but the schedule rounds it up to 1. 

I've used IF (OCCUPANT LOAD < 1, ROUNDUP) but Revit is not accepting that formula.

1 ANTWORT 1
Nachricht 2 von 2
David_W_Koch
als Antwort auf: meganAPYT4

Are you not wanting to round up all values to the next whole person?

 

If you only want to round up when less than one, then you need to calculate the value and then test to see if it is less than one.  If so, round up the value, if not, pass through the value.  You could do that in one calculated value, with a lot of repeated calculation.  It may be easier to understand and maintain if you use two calculated values.

 

OCCLoadCalc = Area/AreaPerOcc

(where Area/AreaPerOcc is a placeholder for the formula you already have for calculating the occupant load based on the area of the Area)

 

Then apply the rounding if needed:

OCCLoad = if(OCCLoadCalc < 1, roundup(OCCLoadCalc), OCCLoadCalc)

 

We would just use roundup on the original calculation for all cases, as we would not report a fractional number of people.


David Koch
AutoCAD Architecture and Revit User
Blog | LinkedIn
EESignature

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report