Also, I've tried using Case (similar parameters mentioned above), but can't make it work either. I'm sure I'm doing it all wrong. It seems the Case should work great. If "x", then "y", Otherwise, "z". But, I can't get it to work right. =(
Some things to check.
MyField is a calculation field and the calculation result = container.
( there is a popup menu bottom left of the specify calculation window.)
if( fieldX = fieldY; table::container1; table::container2)
If, not Case. That worked great. Thank you so much! I have been fighting this for what seems forever. ;)
One more thing! =) How can I add a parameter that if the field = "", use global2? I tried checking the "do not evaluate if all referenced fields are empty", but that doesn't seem to help.
is this what you're after
If( not IsEmpty( fieldX) and fieldX = fieldY; cotainer1;cotainer2)
Exactly! Thanks again!!