Removing rounding from a schedule

[loriGZUVH]

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!

[ToanDN]

Switch to Formatting tab, select the calculated value field and you will
see the units formatting button.

[barthbradley]

.

[loriGZUVH]

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.

[semhustej]

I think the formula for rounding down might help you. rounddown(x)

You can read about it here:

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2014/EN...

Tomas

[loriGZUVH]

That got me closer....Is there a way to only round down the grand total?

[loriGZUVH]

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???

[RDAOU]

@loriGZUVH 

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 

[loriGZUVH]

I correct the total units but am still having issues with the calculation.....

[loriGZUVH]

It looks like it is rounding my stalls/unit and then multiplying it by the total units.

[RDAOU]

@loriGZUVH 

change formatting of Req Stalls to General

[loriGZUVH]

that didn't fix it 😞

[RDAOU]

@loriGZUVH 

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