10 Replies Latest reply on Sep 28, 2010 8:48 AM by jamezj7

    If calculation


      Hi all,


      "Field C" is dependant on a value being entered in either "Field A" or "Field B" but only one field can be chosen. So if "Field A" is 3 "Field B" must be 0 and vise vesa. This value is then multiplied by 0.18 and added to "Field C"


      Currently I have a simplified field notation that requires me to manually enter a value of 0 for the non used field to complete the calculation. How can I make it so that when a value is entered in "Field A" a value of 0 is entered in to "Field B" automatically and vise versa?


      Here is the field notation I have that is in "Field C", hopefully it makes sense.


      (Field_A * 0.18) + (Field_B * 0.18)