AnsweredAssumed Answered

Using a range in an equation

Question asked by Oli Sparrow on Nov 6, 2017
Latest reply on Nov 6, 2017 by Dave Bear
  • Comment • 5

Hi all,

I have a feature pattern that creates instances between 2 and 5 depending on the length of a rail (equation driven).

I basically need to suppress or unsuppress another feature based on whether that instance count is odd or even, or another way of looking at it is that if it's '5' or '3' I need it unsuppressed, if it's 4 or 2 I need it suppressed.

 

Can I specify a range of values (ie 5:3 like excel) or possibly use iif to look at odd or even numbers?

 

The general idea would be:

= IIF ( "RACK INSTANCES@RACK PATTERN" [ is an even number ] alt. [ is #2 or #4 ]  , "suppressed" , "unsuppressed" )

 

Thanks!

Oli

Deepak Gupta
Deepak Gupta Nov 6, 2017 5:17 AM
Correct Answer

You can try using OR to use two values (either 3 and 5 OR 2 and 4). Another option might be to use nested IF condition.

 

Here is working example for both

 

See the reply in context
No one else had this question

Outcomes