BPS - Making total value not changable
Hello Gurus,
I am having a simple layout ( as below) wherein total value is distributed equally across Terms on service. Say I have total values = 100 and Terms = 10, then for every month, the amount is 10.
Transaction_ID Month Amount
1001 Jan 10
1001 Feb 10
1001 Mar 10
1001 Apr 10
1001 may 10
1001 June 10
1001 July 10
1001 Aug 10
1001 Sep 10
1001 Oct 10
============================
Total 100
However, the amount fileds for individual month is editable and user can change values there if they want to. Ex: say for month FEB, user changed values from 10 to 20, then total is getting changed from 100 to 110.
Is there any way to avoid total to change ? can we keep total same all the time? Later I would like to display the messge saying that total amount cannot be changed, so that if user increasing individual month, they have reduce for some other place.
Transaction_ID Month Amount
1001 Jan 10
1001 Feb 20
1001 Mar 10
1001 Apr 10
1001 may 10
1001 June 10
1001 July 10
1001 Aug 10
1001 Sep 10
1001 Oct 10
============================
Total 110