I have 3 felds. Field1 and Field2 contain numbers. Field3 is the result where the formula needs to be placed. When Field1 = 1 AND when Field2 = 2 I want to display a value of 1 in Field3 (or a value of true as example) The formula i tried to come up with is:
substring("1", 1, (((Field1 = 1) + Field2 = 2) = 3))
I problem is that I end up with only able to constrain one of the fields but not both. This is needed because another arument using the same field2 conflicts with this when it is not working properly.
Any help is much appreciated.
Thanks,
Jason