2 Replies Latest reply on Jul 30, 2010 10:38 AM by fluffyone

    help with sum please

    fluffyone

      Title

      help with sum please

      Post

      Hi Group

      I have a calculation field, and it calculates a sum from a couple of fields but I would like to override the answer if another field has an input i.e:

      f1 = 10
      f2 =20
      f3 =0

      cf1= f1 x f2 = 200

      but if f3 = 40
      then cf1 would equal the 40 not 200

      Does this make sense?

      regards

      Fluffy