Help in adding a calculation field

Discussion created by kwrigh on May 30, 2012
Latest reply on Jun 3, 2012 by robwoof

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,