I am trying to stop a calculated value in a schedule from rounding but I don't see an option under field formatting. Is there another way to do this?
Here is the calculated field
Here is what the schedule spits out.
I need the highlighted numbers to drop the decimal without rounding up so that it shows that I only need 177 stalls instead of 178.
Thanks for your help!
That sounds like what I am doing. Can you post a screenshot?
It sounds like you are saying to go to Formatting -> Field Format -> Rounding
My issue is that it keeps rounding up and I just want it to drop the decimal so 177.5 shows as 177 not 178.
I think the formula for rounding down might help you. rounddown(x)
You can read about it here:
Tomas
That got me closer....Is there a way to only round down the grand total?
Actually, it may have made new problems....the formula is giving me the wrong numbers???
Looking at the first row. It is supposed be 13*1.25=16.25 but it is giving me 14???
You have an issue in the Total units Column.... 4 x 3 unit Townhouse is 12 units not 13 and 13 x 4 units Townhouse is 52 not 51
The correct figures should result the below when rounding down ..177
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
I correct the total units but am still having issues with the calculation.....
It looks like it is rounding my stalls/unit and then multiplying it by the total units.
change formatting of Req Stalls to General
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
isn't Required Stalls = total Units x Stalls per Unit? ...what is Units per Building doing in your formula?
Use Integer for the parameters .... Number of Buildings and Total units
otherwise upload it...can't do any more guesses
YOUTUBE | BIM | COMPUTATIONAL DESIGN | PARAMETRIC DESIGN | GENERATIVE DESIGN | VISUAL PROGRAMMING
If you find this reply helpful kindly hit the LIKE BUTTON and if applicable please ACCEPT AS SOLUTION
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.