topic Problem when using expressions to calculate the number of occupants automatically in Collaborate forum
https://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280092#M36725
<DIV class="actalk-migrated-content"><R>Hi,<BR />
<BR />
I;m struggling with the following: I use follow the directions of this page: <A href="https://helpcenter.graphisoft.com/knowledgebase/86867/" target="_blank">https://helpcenter.graphisoft.com/knowledgebase/86867/</A> to calculate the number of occupants. The problem I face is when I have a parameter of occupancy that is not an integer, like say 2.6 or 3.2 those number get rounded up resulting in erroneous results. The expression used is<BR />
STRTONUM ( SPLITRIGHT ( {Property:ZONES/Occupancy type}, "| ", 2 ) )<BR />
<BR />
Why is this happening? Does the roundup function in the Occupants affect also the Occupant load value?</R></DIV>Thu, 01 Jul 2021 15:03:30 GMTAchille Pavlidis2021-07-01T15:03:30ZProblem when using expressions to calculate the number of occupants automatically
https://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280092#M36725
<DIV class="actalk-migrated-content"><R>Hi,<BR />
<BR />
I;m struggling with the following: I use follow the directions of this page: <A href="https://helpcenter.graphisoft.com/knowledgebase/86867/" target="_blank">https://helpcenter.graphisoft.com/knowledgebase/86867/</A> to calculate the number of occupants. The problem I face is when I have a parameter of occupancy that is not an integer, like say 2.6 or 3.2 those number get rounded up resulting in erroneous results. The expression used is<BR />
STRTONUM ( SPLITRIGHT ( {Property:ZONES/Occupancy type}, "| ", 2 ) )<BR />
<BR />
Why is this happening? Does the roundup function in the Occupants affect also the Occupant load value?</R></DIV>Thu, 01 Jul 2021 15:03:30 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280092#M36725Achille Pavlidis2021-07-01T15:03:30ZRe: Problem when using expressions to calculate the number of occupants automatically
https://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280093#M36726
Be sure that the "occupants load" number is a real, natural number (float), and not an integer; this is to be set in the property's value type.<BR />
Then everything should work fine.<BR />
<BR />
I am not aware what the decimal seperator in Greece is. In Germany it's the comma.<BR />
You'll need to have the number in "occupancy type" be in the same format as per your PC's settings.<BR />
<BR />
Lastly I would rather "ROUNDDOWN" than up... since rounding up makes no sense – if there is not enough space left you can't cram more people in, right?!Fri, 02 Jul 2021 15:16:36 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280093#M36726runxel2021-07-02T15:16:36ZRe: Problem when using expressions to calculate the number of occupants automatically
https://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280094#M36727
Thanks @runxel.<BR />
<BR />
Actually I used "ROUNDUP" because I'm calculating the maximum number of people that can fit in a given space, according to the fire standardsWed, 07 Jul 2021 12:16:38 GMThttps://community.graphisoft.com/t5/Collaborate-forum/Problem-when-using-expressions-to-calculate-the-number-of/m-p/280094#M36727Achille Pavlidis2021-07-07T12:16:38Z