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

Posted on 2006-04-26
Medium Priority
Last Modified: 2008-02-01
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?
please help.....
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)?
LVL 22

Expert Comment

ID: 16547182
You can try:

Balance = [MaintenanceCost] - Max[Cumulative]


Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

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 …

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.

Join & Ask a Question