Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Conditional Formula inside Family to be use in Schedule

1 REPLY 1
Reply
Message 1 of 2
nichkherbsman
109 Views, 1 Reply

Conditional Formula inside Family to be use in Schedule

Hi,

 

Good day. I need help to achieve the formula inside a certain family to be used in formula. I am aiming actual length, just like images below : 

nichkherbsman_0-1663136308648.png

So I tried to make this rules / condition but can't find the correct statement for parameters.

Cap end = 12mm
I will consider the rules for this:

If the LED Drawing length is less than 1800 then (LED Drawing length - Cap end)/25 = Actual number of LED(rounddown)
(Acutal number of LED * 25)+12 = Actual Length of LED

If the LED Drawing length is greater than 1800 but less than 3600 then ((LED Drawing length-(Cap end*2) / 2) = LED Drawing length A
LED Drawing length A / 25 = Acutal number of LED A (rounddown)
(Acutal number of LED A * 25)+12 = Actual Length of LED A

((LED Drawing length-(Cap end*2) -LED Drawing length A) = LED Drawing length B
LED Drawing length B / 25 = Acutal number of LED B (rounddown)
(Acutal number of LED B * 25)+12 = Actual Length of LED B


If the LED Drawing length is greater than 3600 then ((LED Drawing length - (Cap end*3) / 3 ) = LED Drawing length A
LED Drawing length A / 25 = Acutal number of LED A&B (rounddown)
(Acutal number of LED A * 25)+12 = Actual Length of LED A & B

((LED Drawing length-(Cap end*3) -LED Drawing length A+B) = LED Drawing length C
LED Drawing length C / 25 = Acutal number of LED C (rounddown)
(Acutal number of LED B * 25)+12 = Actual Length of LED C

 

I attached some revit sample and family

NiCHKCiD
BIM Modeler
Technical Officer
Technical Designer
Sr. Draftsman
1 REPLY 1
Message 2 of 2
mhiserZFHXS
in reply to: nichkherbsman

https://knowledge.autodesk.com/support/revit/learn-explore/caas/CloudHelp/cloudhelp/2020/ENU/Revit-M...

 

Basically

 

if (given condition, value if true, value if false)

 

Or if using a yes/no parameter

 

if (parameter, value if yes, value if no)

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report