Give this a try:
- Create a report variable, rnTotal. Set it to 0 and set the calculate option to SUM, and reset it at end of report. (I know .. this sounds strange so far!)
- In the OnExit Expression of the Data Group Footer, enter the following line:
_VFP.SetVar('rnTotal', rnTotal + lineofcreditfield )
In the Report total, use the rnTotal variable -- no need to mark any special calculation options on it because you've already taken care of that.
Cathy
>I have the following detail. Want the Total: to be 500,000 - not 1,000,000. I only want to add in the line of credit when the customer changes. Need to do it with variables, not with group footer. (the true report is just a bit more complicated. just trying to get to the basics)
>
>
>customer Line of Credit
>Henry 200,000
>Henry 200,000
>Robert 300,000
>Robert 300,000
>
>Total: 1,000,000
>
>Want - Total: 500,000