Running CR 10 Pro

Got a report that shows profit totals for each sales person and breaks down by total -today and today +30. The math is correct, in that it appears to have the correct dollar amounts but it doesn't reset to 0 for each rep.

Calculation formula below is placed in the details section and the -T formula is placed in the GH for the rep.

What it is shows...
Rep      Detail   Profit -T     Profit to 30
John D    
          40.00
          60.00
          50.00
                     100.00            50.00
----------------------------
Sally R    
          25.00
          25.00
                     150.00            50.00       

Sally R's totals should show "Profit -T"=50.00 and "to 30"=0.00 instead including the dollar amounts from the previous rep, should reset to zero before doing her calculations.


**** Calculation formula: *****
WhilePrintingRecords;

CurrencyVar L9PriorToToday;
CurrencyVar L9LessThan30;

If Not IsNull ({tblOpportunities.EstimatedCloseDate}) then
If (DTSToDate ({tblOpportunities.EstimatedCloseDate}) < (Today))
then (L9PriorToToday := L9PriorToToday + {tblQuotes.Profit})
else If (DTSToDate ({tblOpportunities.EstimatedCloseDate}) <= (Today) + 31)
then (L9LessThan30 := L9LessThan30 + {tblQuotes.Profit})

**** -T formaula ****
WhilePrintingRecords;

CurrencyVar L9PriorToToday;

Thank you but where in the group header would I add the new formula?

place it anywhere in the group header.

Edited by DBlank - 10 Oct 2014 at 3:58am

change them to shared variables or add in the

Edited by DBlank - 10 Oct 2014 at 7:17am