Skip to Content
Former Member
Aug 25, 2009 at 06:25 PM

Current Month - Formula


I need to calculate sales for the following columns:

August Sales July Sales June Sales May Sales

I know I could use a parameters with date ranges for each column to calculate this, but is it possbile to do this without always needing to go into the report and maually typing in dates? Is it possible to formulate a procedure for each coulumn something like "Date Field in Current Month" and then "Date Field in Current Month - 1, etc.

Thanks for your heklp in adavance.

Thanks Jim Dyer