I the above code I mensioned it gives output as a1 g1 1 1 1000 100 100 900 0 a1 g2 1 2 1000 50 50 850 0 a2 g1 2 1 500 100 100 400 0 a3 g3 3 1 400 200 200 200 0 The problem I am facing is in the third row. What I want is, once a gurantee is allocated to a particular loan its value should be updated in te rest of the rows. Hence in third row, gurantee_amount should be 0, thus allocated=0 and unallocated=500. So my desired output is: a1 g1 1 1 1000 100 100 900 0 a1 g2 1 2 1000 50 50 850 0 a2 g1 2 1 500 0 0 500 0 a3 g3 3 1 400 200 200 200 0 You can give me totally new code if that works. But for now yes I need these if statements to run in sequence and i dont need any else statement. I didnt get your last concern. Please elaborate.
... View more