Controlling the value of one series according to value of another series

Hello,

Example : 1.There are two series phase 1 % & phase 2 %. In case we entered phase 1% = 70% then it should allow only up to 30% into the phase 2 % series.Basically the sum of ‘Phase-In 1 %’ + ‘Phase-In 2 %’  should not exceeds 100%. If its exceed 100% it will show message that the value is more than 100%.

2.If this cannot be achieve then, if the sum of ‘Phase-In 1 %’ + ‘Phase-In 2 %’ exceeds 100%, Demantra should not attempt to transfer more than 100%: this could be achieved below example:

Phase-In 1 %’ = 50% and ‘Phase-In 2 %’ = 100%.

Because Demantra cannot transfer more than 100% of an item, the final total transfer percentage needs to be brought down to 100%. Thus: ‘Phase-In 1 %’ = 50%*(100%/150%)=33% and ‘Phase-In 2 %’ = 100%*(100%/150%)=67%.