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: 

Removing rounding from a schedule

12 ANTWORTEN 12
Antworten
Nachricht 1 von 13
loriGZUVH
1233 Aufrufe, 12 Antworten

Removing rounding from a schedule

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

loriGZUVH_0-1620333499601.png

 

Here is what the schedule spits out.

loriGZUVH_1-1620333666768.png

 

 

 

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!

 

12 ANTWORTEN 12
Nachricht 2 von 13
ToanDN
als Antwort auf: loriGZUVH

Switch to Formatting tab, select the calculated value field and you will
see the units formatting button.
Nachricht 3 von 13
barthbradley
als Antwort auf: loriGZUVH

.

Nachricht 4 von 13
loriGZUVH
als Antwort auf: ToanDN

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.

Nachricht 5 von 13
semhustej
als Antwort auf: loriGZUVH

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

Nachricht 6 von 13
loriGZUVH
als Antwort auf: semhustej

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

Nachricht 7 von 13
loriGZUVH
als Antwort auf: loriGZUVH

Actually, it may have made new problems....the formula is giving me the wrong numbers???

 

loriGZUVH_0-1620835486140.pngloriGZUVH_1-1620835509899.png

Looking at the first row. It is supposed be 13*1.25=16.25 but it is giving me 14???

Nachricht 8 von 13
RDAOU
als Antwort auf: loriGZUVH

@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 

 

 

rd.jpg

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


Nachricht 9 von 13
loriGZUVH
als Antwort auf: RDAOU

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

loriGZUVH_0-1620842410704.png

loriGZUVH_1-1620842426056.png

loriGZUVH_2-1620842482220.png

 

 

Nachricht 10 von 13
loriGZUVH
als Antwort auf: loriGZUVH

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

Nachricht 11 von 13
RDAOU
als Antwort auf: loriGZUVH

@loriGZUVH 

 

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


Nachricht 12 von 13
loriGZUVH
als Antwort auf: loriGZUVH

that didn't fix it :enttäuschtes_Gesicht:

 

loriGZUVH_0-1620843828148.png

 

Nachricht 13 von 13
RDAOU
als Antwort auf: loriGZUVH

@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 

 

 

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.

In Foren veröffentlichen  

Autodesk Design & Make Report