Conditional Statements - Text Values? for 2009

[cek]

Does anyone know if the Revit Architecture 2009 will support "text" values in their conditional statements?

I guess this also prompts the question will a alpha/numeric solution be permitted? or does the text value already support numbers?

I also ran into a syntax wall with a double conditional like this:

IF(OCC Correlator=5,IF(FS Correlator=100,100,75))

Where the second conditional IF is consider a Bad IF Statement in Revit. I ran this conditional trough Excel and it had no problem accepting the syntax.

So as another question will back to back conditionals be accepted in Revit 2009?

Thanks

[archjake]

Carl, Not sure about 2009, but I believe that you can do multiple if statements. Check the following link.

http://revitfamilies.blogspot.com/2005/10/revit-formulae.html

Otherwise there are If And statements and If Or statements that are allowed but they are formated a bit differently.

Formulas are fun in Revit aren't they! Just wait until you try to write formulas with yes/no parameters. Formula logic gets thrown out the window.

[cek]

Thanks Jake,

That "AND" operation took care of the back to back "IF's" here's the syntax I used.

IF(AND(OCC Correlator=5,FS Correlator=100),100,75)

So now my Table 1019.2 One Exit Max Travel Distance formula is working correctly in my Occupancy Schedule. I love this progam!

I thought I was going to be able to stump you at the next User group meeting with that one. Oh well. I checked the web site you gave me to see if I could use a text value in a conditional statement but there was no mention of it. I guess we will just have to wait and see. Until then I'll probably use a '0' for a NP (not permitted) solution.

The one thing that bugs me though is once you commit the formula parameter to the schedule you can't go back and view the formula structure or edit it. I've been keeping the formulas in a Word document so I can go back and enhance them later.

Given the time to set up these formulas I'm beginning to realize how valuable they are.

Thanks Again!
See you at the next User Group Meeting.
Carl

[archjake]

Carl,

Sounds like you should be the one giving the code analysis presentation at the next users group. I'll be presenting occupancy tabulation using a key schedule with info straight from the code and a required plumbing fixture table which I'm also trying to tie to a key schedule wint info from the code. I'm having Andy do up a presentation for the allowable area family that we have. Make sure to bring your schedules.

You can go back to view and edit the forulas. Just select the parameter and hit the edit button. See the attached image

Perhaps you and I can get together to pick each others brains on what information would be useful and how we can come up with Revit producing the results. You have the years of experience and I like to find a solution. It could be worth something. If not our time; $$.

[cek]

Sometimes the simplest things allude me. I've been using the Edit function on the other parameters don't know why I just didn't use it on the calculation parameters. I think it might be habits from other programs, double clicking when I should be right mouse clicking, when I should be control selecting, add nausuem.

Anyways I'm available after work at ADG if you want to come by. Give me a call and we can compare IF statements.

[david.metcalf]

Isn't Tucson over presented in this forum today? :lol:

[cek]

The Revit Wave just happens to be cresting in Tucson today.