Dynamic Component IF statement text comparison
-
I'd like to have a particular group within a component be hidden based on one of the component's variables. For example, if you set the variable "TYPE" to "DOUBLE", I'd like to hide certain groups. However, this formula is not working out:
=IF(EXACT(OPENING!TYPE,"DOUBLE}"),FALSE,TRUE)
It is not accepting "DOUBLE" as a valid comparison argument.
Any thoughts?
-
That shoud work. You could try putting quotes around the one attribute:
=IF(EXACT("OPENING!TYPE","DOUBLE}"),FALSE,TRUE)If not, post the model or an example model demonstrating the problem.
-
Thanks Jim. I have no idea why but my original code is now working! SU did not like the quotes around the OPENING!TYPE reference but something in adding the quotes reset the field and made it read properly again.
I experienced this same glitch on 4 other groups I had to update in the component so it was no a fluke. I'll keep an eye out and if I can figure out what happened exactly, I'll let everyone know.
-
OK, I think I figured out what was causing the problem. When you type double quotes into the dynamic component (at least in Sketchup for Mac) the double quotes are sometimes changed from " to “ causing the formula to throw an error.
Thanks nonetheless for your help Jim!
Advertisement