We are using Crystal Reports version 11. We are summing up fields that have different rates.
For example we have a Standard Rate of $100.00 then a Driver Rate of $50.00.
When we are summing up the Standard Rate it is straight forward because we add each record.
When we use the Driver Rate, even though it may have several records, we just want to sum the first record that we have it grouped by.
The problem comes in when we need to generate totals. We want to sum all of the Standard Rates with All of the Driver Rates. What happens is it doubles, triples, etc. the Driver Rates (ofcourse depending on the number of records).
Example:
Standard Rate $100
Standard Rate $150
Driver Rate $50.00 (browse results has 3 records)
Total = $400
We want the Total to be $300.00.
Is there some way to do this? We cannot change our data groupings and we have tried adding two Running Totals but we get no results.
Thanks
For example we have a Standard Rate of $100.00 then a Driver Rate of $50.00.
When we are summing up the Standard Rate it is straight forward because we add each record.
When we use the Driver Rate, even though it may have several records, we just want to sum the first record that we have it grouped by.
The problem comes in when we need to generate totals. We want to sum all of the Standard Rates with All of the Driver Rates. What happens is it doubles, triples, etc. the Driver Rates (ofcourse depending on the number of records).
Example:
Standard Rate $100
Standard Rate $150
Driver Rate $50.00 (browse results has 3 records)
Total = $400
We want the Total to be $300.00.
Is there some way to do this? We cannot change our data groupings and we have tried adding two Running Totals but we get no results.
Thanks