I would like to create a formula that will:
Sum the {Amt} fields only from records that have the identical data in another field {ticket/voucher #}.
For example:
Records 1, 7 and 14 have the identical data in {Ticket/Voucher #}. The formula would sum the amounts only from those records
1717.40
- 980.00
- 250.00
and put the total 487.40 in {Formula field}.
The same would go for records 10, 12 and 15
and 11, 16 and 13.
See link to image of my table.