Include new field with subtotals/status in load script

[hansdevr]

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

[hansdevr]

That hardly seems fair, since Sunny put more work into it (adding an attchment, etc.)

[sunny_talwar]

You can mark one as correct and other as helpful

[Kushal_Chawda]

hahaha. nahi bhai wo to ab ye hi decide karega..

[Kushal_Chawda]

No problem..

[hansdevr]

Anyway, decision has been taken: you're both living on Olympus!!!!