Trying to develop an IF or AND statement in SW Equations to drive a dimension value "A" based upon a range of values "X" where (X >= 1 & < 5) and another range for (X >=5 & < 10)? How do I accomplish this with a simple example please?
I feel you can much better control that via design table utilizing the power of excel.
This seems to work,, use nested if's
I'm going to have to give this thread a friendly bump. I'm having similar issues (features driven by more than one global variable), and Rob's solution above works perfectly. I haven't seen it literally anywhere else.I'm sure plenty of other people could use it as well.
This is a variation of Rob's solution,
Perhaps it would be a little easier to read for bigger number of ranges.
Retrieving data ...