Set the shared variable in the subreport, then access it in the main report.  You would probably want to store it in another variable, or if you never reset it, just keep having your subreport update the shared variable and report on it at the end of the report.

HTH

 

shared numbervar subTotal;

global numbervar mainTotal := mainTotal + subTotal;

 

This will sum any value that you choose. 

 

Notes: Global variable are only available to the report that they are written in (so scoped to only the main or only the subreport).  Shared variables are allowed to cross the line between main and subreport.  If creating your totals, remember that if you have grouping and you want the totals to reflect the values in a group or set of groups you will need to reset the variable to 0 at some point, and you might need to increment another variable to keep a higher group totals correct.

 

HTH

 

it's always easier to figure out what is going wrong when you can see the pieces instead of the whole.

 

HTH

 

$                       KWH           Average

207.59             2022               -

167.33             1567             0.132

162.98             1469             0.114

212.63             2012             0.081

 

1st                  main repot     average from

subreport                              subreport

column                                   column $/KWH

 

formula is (@@@MainFormula)/(bi_Hist_Usage.Bi_Usage)

 

I just cant seem to get it to reset. I have the average placed in the group header section(date). It all calculates correctly just one row off.