I have one table ClaimDetails and it has entities named RepairMount and MaintenanceCost. I have calculate cumulative amount for Repair Amount using running sum.
e.g Repair Amount Cumulative
how am i going to calculate balance of the Maintenance Cost using cumulative amount? My calculation formula should be :
Balance = [MaintenanceCost] - [Cumulative]
The figure I had is wrong.
eg. Maintenance Cost = 1000 when i run the calculation, it shows balance = 850 instead of 700. I believe it takes the first number (150) and not the last number (300).
how to make system recognize the last number which is the total of cumulative amount?