Re: Math - Contrain 2 fields to equal a value

Jimmy — Fri, 28 Oct 2011 21:45:40 GMT

It looks like you want:

substring("1", 1, (Field1 = 1) and (Field2 = 2))

I assume you want the result to be blank when it doesn't pass those conditions? If you want Field3 to be 1 when the condition is true and 0 when it's false, this should work as the formula:

number((Field1 = 1) and (Field2 = 2))

Math - Contrain 2 fields to equal a value

mrmapi — Fri, 28 Oct 2011 21:12:35 GMT

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

General

Re: Math - Contrain 2 fields to equal a value

Math - Contrain 2 fields to equal a value