3 Replies Latest reply on Aug 10, 2012 9:39 AM by philmodjunk

    Calculation formula please



      Calculation formula please


      Hello friends, it's been a while.

      I am sure that this should be a simple one, but I can't seem to work it out. I need a formula which will return the summery (sum of all records) in the field 'outstanding' from the 'total' field, but only for records which have the 'status' field containing 'active'.


      Thank you in advance, Jo :)