PDA

View Full Version : 2014 Nested Yes/No Statement



kmarquis
2014-08-05, 03:10 PM
I've looked everywhere for this and I just don't understand the syntax. I have a Nested Detail Item family for Partition Type Details. The user types in the number of layers of Gyp on the right and the left which is tied to a series of yes/no parameters. I have a sealant graphic at the head of the partition. I want the sealant for the first layer of gyp to go away if there are more than one layers of Gyp and also if there are no layers of gyp.

How do I write that?

I basically want both of these things to happen but I can't figure out how to nest them so the box is unchecked when one of these two conditions happens:

not(No of Layers Right>1) and then also not(no of Layers Right=0)

damon.sidel
2014-08-05, 03:17 PM
I think you want to write:

AND(NOT(No of Layers Right>1), NOT(No of Layers Right=0))

If you want "This AND That" --> AND(This, That)
where
This = NOT(a)
That = NOT(b)

I go to this page all the time for my formulas: http://www.revitforum.org/tutorials-tips-tricks/1046-revit-formulas-everyday-usage.html

nchapman449919
2014-08-05, 04:13 PM
If I'm reading your post right then you are going to use "Or" instead of "And". If you use "and" then both of them need to be true which should never happen has you cant have no gyp but also more than one layer.

So it would look like this:
not(or(No of Layers Right < 2, No of Layers Right = 0))

It would make more sense to just do this:

No of Layers Right>1

Which will give you if its equal to or less than 1 turn off.

Or it could look like this:
not(No of Layers Right < 2)

These are all doing the same thing but the first is overkill as the first statement "No of Layers Right < 2" covers the value 0. I showed it to give you an example using "or". I still would use the second as that's the easiest for users to understand.