I have MTD, YTD, and Lifetime totals that are sorted based on another field and a date range. I have one group that collects totals if the user forgets to fill in the field. This is where it gets strange.
If I run the report my YTD and Lifetime totals are sorted correctely but the MTD numbers put the totals in the the field that a user forgets to put in the information. I thought maybe that the date restrictuin might be screwing things up so I copied the YTD Formula into the MTD formula field just to see if the date was casuing a problem. When I run the report with the two forumlas exectly the same I get the same result as before. The MTD numbers do not change except that the totals increase to the YTD number.
Just wondering how the same formula in the same section of a report can return two different results?
IP Logged