The report is based on the completed activity date. What is being displayed is the YTD sales, trailing 12 month totals (from the prior month of the completed activity), Subsequent Sales (any sales after the activity happened), Run Rate((The subsequent sales/date difference from the max date range of the date parameter and the activity date)/(trailing 12 months/12)*100). I have the following grouping, G1 is the completed user and G2 is the contact.

 

All the above fields are being displayed on the G2 level. This part works fine.

The problem I am having is that I need to now add run rate by G1. I created a reset formula and put it in the GH1 and put the display in the GF1, but what ends up happening is that the reset is happening per page and not on change of G1.

When I remove the reset value it creates the value without a reset on every page.

 

Any help would be helpful.

 

Thanks

Your reset is in the Group Header, and you are repeating the group header on every page, so it keeps reseting...had to hit my head against a wall to figure that out on one of my reports....

 

How to get around it...

The simple solution is to create another group with same conditions as the current GH, place it above the current GH, and suppress it (you don't need to see, you just need the value). Place the reset formula in this section and all should work.

 

HTH

Thanks for the info. I would never of thought of that, but it did work.