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: 

plumbing count formula issue

7 ANTWORTEN 7
GELÖST
Antworten
Nachricht 1 von 8
Ian_H
578 Aufrufe, 7 Antworten

plumbing count formula issue

I found a family that had formulas to calculate plumbing fixtures, but it was based on 2012 IBC. I was updating the formulas for the latest California code but don't seem to be getting the correct result. The women's count is 150, so it should use 4-(150/200) which equals 3.75, but it's showing -5. 

 

Can someone help me pinpoint where the issue is?

 

Ian_H_0-1680715880435.png

 

Beschriftungen (1)
7 ANTWORTEN 7
Nachricht 2 von 8
ToanDN
als Antwort auf: Ian_H

Share the family here.

Nachricht 3 von 8
Ian_H
als Antwort auf: ToanDN

Here it is

 

Nachricht 4 von 8
ToanDN
als Antwort auf: Ian_H

Your < and > are wrong in the formula below, they should be reversed.

 

if(Women > 25, (1 - (Women / 25)), if(and(Women < 25, Women > 50), (2 - (Women / 50)), if(and(Women < 50, Women > 100), (3 - (Women / 100)), if(and(Women < 100, Women > 200), (4 - (Women / 200)), if(and(Women < 200, Women > 300), (6 - (Women / 300)), 0)))))

 

After reversing > and <:

 

ToanDN_0-1680717489143.png

 

 

Nachricht 5 von 8
Ian_H
als Antwort auf: ToanDN

Thanks for catching that. I'm glad it's a simple fix, but I feel dumb for not catching that. lol

Nachricht 6 von 8
Ian_H
als Antwort auf: Ian_H

@ToanDN 

Is there a way to denote the number of decimal points you want in a number? 

 

Ian_H_0-1680793896142.png


In the screenshot you can see there is a number that is 6 decimals deep and one that is 3 decimals deep. I don't want it to round to 2 decimals. 

 

Nachricht 7 von 8
ToanDN
als Antwort auf: Ian_H

Format the label's units.  Example to set it to 6 decimal places.

 

ToanDN_0-1680796382457.png

 

Nachricht 8 von 8
Ian_H
als Antwort auf: ToanDN

Thanks again

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