Jump to content

This topic is 8290 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

I want to be able to show a running 12 month sales total. Where at the end of each month the new month is added and the oldest month is dropped off.

Thanks for your help,

HJ

Posted

Not too sure if this is really what you're after, but my PowerBook battery is running flat and I left the charger at work... But it might be a start.

So, on any date in June 2002, for example, you would want to show sales from 1 June 2001 to 31 May 2002 inclusive? If you script a find like this, it should bring up the previous 12 months records, excluding any in the current month.

Enter Find Mode[]

Insert Calculated Result[Payment_Date,DateToText(Date(Month(Status(CurrentDate)),1,Year(Status(CurrentDate))-1)) & "..." & DateToText(Date(Month(Status(CurrentDate)),1,Year(Status(CurrentDate)))-1)]

Perform Find []

You could then have a sub-summary report on the found records by month, not showing the body part, with running total summary fields in the sub-summary parts.

Is that what you're trying to achieve?

This topic is 8290 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.