kwrigh

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,

 

K

Outcomes