Solved

# How to calculate cumulative figure in report and balance using total cumulative figure

Posted on 2006-04-26
Medium Priority
821 Views
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
150                           150
100                           250
50                             300

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?
0
Question by:cujee75

LVL 26

Accepted Solution

jerryb30 earned 500 total points
ID: 16543048
Can you show the corresponding MaintenanceCost data?
How is Balance = MainteanceCost-Cumulative different from
Balance = MaintenanceCost - sum(RepairAmount)?
0

LVL 22

Expert Comment

ID: 16547182
You can try:

Balance = [MaintenanceCost] - Max[Cumulative]

Flyster
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
###### Suggested Courses
Course of the Month14 days, 4 hours left to enroll

#### 809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.