I'm typing this as I'm reading it in order to better understand what you want. your taking the area/occupancy factor to find the total occupants. then your using the .4999 to round up. sounds good so far. now you've got a number that is rounded that you want to add as it appears. (i.e. no mystery decimals you can't see) here is the theory explaination of what I did before: when you take the area and divide it by an occupancy factor im guessing that you took something like 250sf/10. now the answer to that is 25. right? wrong. its 25sf. the sf is important. the area integer i did in my previous explaination took the number 25sf and made it 25 by dividing by 1sf. so what I would do is (im paraphrasing from the previous post too so pay attention to that) take your area sf and then divide by the occupancy factor (forget the .4999 right now. now create a occupancy integer field and for the equation make it (calculated occupancy load field+ .4999) /1sf okay now create another field that is occupancy rounded and make its equation occupancy integer * 1sf hide the occupancy factor whatever field and the occupancy integer field. display only occupancy rounded column (you can change its display name to occupancy load. the workaround of the /1sf and the *1sf removes the hanging mystery decimals. if it does/doesn't work for you let me know.
----------------------------------- I like scooters. and motorcycles. |