Simple formulas in dimensions

[Marlec]

hello,

I'm on Revit Architecture 2017.2, and because of the law where in Québec, it's in french...

So, i'm creating a family with some dimensions that needs to be considered: the part cant be shorter than 4" (102mm minimum, metric project).

I've checked the help section to see how do I write my formula, but I dont know if it's a translation thing, the exemples shown dont work, tried ones that are not related to what I need and keep getting errors in the formulas...

My dim's name is "LONG1" in the parameters box (i'm translating here...), default value is 200, my formula was: "=LONG1 > 102.0", wich gives me an "incompatible values"...

Also used "= LONG1 > 102.0" and "= (LONG1 > 102.0") and some others...

Where's my mistake? 

And is there a place / link that precisely tell where a space is needed or not in a formula? is it the same "language" as Autocad?

Thanks in advance for your help!

Marlec

[barthbradley]

you using an IF Statement; correct? For example: =if(Long1>102, 200, Long1) 

...IF (<condition>, <result-if-true>, <result-if-false>)

 ...here's an EXCELLENT reference. Check it out. Print it out. Pin a hardcopy of it above your workstation. 

https://www.revitforum.org/tutorials-tips-tricks/1046-revit-formulas-everyday-usage.html

[Marlec]

Thanks for the reply!

I've put 200.0 just to have something to work with... those are aluminium panel that the general dimensions changes from one manufacturer to another, but if bended, the minimum lenght of the bent part is 102mm... so I thought it would be from 102mm to "beyond"...

I didnt think a "condition" (IF) was needed...

So what would be my formula?

btw: do you have a link to making formulas (from the basics I mean) ?

Marlec

[barthbradley]

---

@Marlec wrote:

So what would be my formula?

---

I'm not sure. What's the condition you want to evaluate?  What value do you want to be returned if that condition is met?  What  value do you want to be returned if that condition is not met? 

[Marlec]

see attached files...

the goal is that not everyone in the office knows the restrictions on such panels...

I wanted to add the formula so that when people stretch the panel, they cant make it shorter than 102mm (166mm including all parameters... 102+3+29+22+10)

[barthbradley]

Oh, that's an easy one to solve. What you want to do is create a control parameter for the Length Parameter. That control parameter would be the one that actually drives the labeled dimension for the Length of the element. For instance, call it Length Crtl.  Then create another parameter called Length. This would be the one that users enter a value into. Now write a formula for Length Ctrl. Let's say you want the minimum to be 200, then the formula for Length Ctrl would read: =if(Length<200, 200, Length).  

Get it?

[patrick.emin]

Hello @Marlec FYI we have a french Revit forum: Revit et BIM - Français - Autodesk Community 

[barthbradley]

Vive la France!  

[Marlec]

So I need to rename the 2 lines in the parameter box. 

(can I delete one since both are same and apply it to when ever needed on multiple dimensions/parameters?)

I'm trying to understand: "Length Ctrl would read: =if(Length>200, 200, Length)."

- "=if" : starts the conditionnal formula...

- "(Length>200" : says that the length has to be equal or higher than 200

- ", 200, Length)" : this part i'm trying to figure out there meaning / use...

[Marlec]

No not "Vive la France"...

more a "Vive le Québec libre!" quote from French General Charles DeGaulle in the 60s...

[ToanDN]

syntax: if (Statement, Result if True, result if False)

your formula: Length Ctrl = if(Length>200, 200, Length)

meaning: If Length > 200 then Length Ctrl = 200; if Length < or = 200 then Length Ctrl = Length

p/s: Go to the Revit FORMULAs link in my signature for more information.

[barthbradley]

I thought we were talking MINIMUM LENGTHS.

If so, the formula should read "<" (e.g. if(Length<200, 200, Length)). If you use ">", that would mean any number in excess of 200 would return 200.  

[Marlec · Accepted solution]

thank you all for the help!

it works, and I'll do some reading to improve...

Regards,

Marlec

[barthbradley]

---

@Marlec wrote:

thank you all for the help!

it works, and I'll do some reading to improve...

Regards,

Marlec

---

You're welcome, @Marlec.  Can you mark my post as the accepted solution please? 

...Excellent resource here.  Print it out and keep a hardcopy by your workstation for quick reference.  

[samih__ayad]

Hello 

i am trying to make 2 filters for area reinforcement 

one is less than 12m 

the 2nd one greater than 12m 

the point is that i want to show the rebars that have rebar length above 12m inorder to make splices for them so when am making vg then filter then adding those filters in the rule box there is only total rebar length and there is no rebar length .

plz helo i tried making parameters but not usefull because after making project parameters i am obliged to enter the bar length manualy 

help plz