I want to use a field to perform a calculation using several other fields. I'm having a little trouble figuring out how to do that.
My calculation is:
If (Field 3 = "Text1", Field 4, Field 6) Endif (Field 3 is text and Fields 4 & 6 are numbers.
The numerical result would be stored in Field 10.
Can someone help me figure out how to write a script to do this?
Thanks in advance,