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

    Calculation formula please

    JoChapman

      Title

      Calculation formula please

      Post

      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 :)