Dynamic Component IF statement text comparison

hank · 10 Dec 2016, 22:49

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?

Jim · 11 Dec 2016, 00:41

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.

hank · 11 Dec 2016, 03:54

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.

hank · 11 Dec 2016, 20:25

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!