Hi Everyone,
I have a table, which includes Claim#, Date of payment and amount payed.
I would like to add a field, which adds up all the payments for a certain claim, and puts the results as an "Amount payed upto now" in a separate field, which I would like to call "Sub". See example below. How would I go about this in the load script?
Any help is very welcome!
Hans
| Claim# | Payment date | Amount | Sub |
| 10001 | 1-6-2004 | € 40,00 | € 40,00 |
| 10003 | 15-4-2016 | € 100,00 | € 900,00 |
| 10003 | 10-4-2016 | € 600,00 | € 800,00 |
| 10003 | 1-4-2016 | € 200,00 | € 200,00 |
| 10006 | 11-5-2016 | € 500,00 | € 10.500,00 |
| 10006 | 1-5-2016 | € 10.000,00 | € 10.000,00 |
