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