Okay. Here is the logic: When a site_typ value is anything but 'T', constrain the diameter value to 0.
Here is the code: if(${site_typ} != T, .= 0)
Seems easy enough but it does not work.
When i change the diameter value to 0, i still get an invalid message. Please help!
Solved! Go to Solution.
Hi Scott,
Try this:
if(${site_typ}!='T',.=0,.>0)
If T can also be 0 you can use if(${site_typ}!='T',.=0,.>=0)
You could also put in a calculation to pre-populate nonT responses.
Cheers, Jamie.
It appears i cannot use a zero in the field. Although that's what I want to do.
The constrain objects everything other than null......I dont understand the logic here.....What am i doing wrong?
Hi Scott,
Try this:
if(${site_typ}!='T',.=0,.>0)
If T can also be 0 you can use if(${site_typ}!='T',.=0,.>=0)
You could also put in a calculation to pre-populate nonT responses.
Cheers, Jamie.
That's it! Thank you.