Home » Categories » Solutions by Business Process » System Features |
Additional Forecast Date Options |
Article Number: 126 | Rating: Unrated | Last Updated: Tue, Jun 20, 2023 at 6:23 PM
|
Datafile Software Additional Forecast Date Options Forecast Dates are a database item type that allows you to analyse and ‘manipulate’ date items.Different types of forecast date are available from the basic forecast date where you add/subtract a set number of days from a date field to analysis options telling you the days of the week or the number of days between a base date and today’s date. Release 6.3 introduces two new forecast options
allowing you to analyse the number of weekdays in the month of any given date
and the number of weekdays so far within the month. This allows, for example, ProFiler reports to
be created showing the average sales value per day in historical months, and
the average sales per day for the current month. When creating a Forecast Date item (Type F) you are asked for the Type of Forecast Date and the Base Date Item to work with plus, for select types a ‘plus’ adjustment value.The new Forecast Date types are: 7 No of Weekdays in Month of Base Date 8 No of Weekdays in Month of Base Date So Far Note that forecast date type 8 also uses today’s date to determine the number of weekdays so far in the month and if the base date is in a previous month holds the number of weekdays within that month. |
Attachments
![]() There are no attachments for this article.
|
Application Memos – Warning or Note
Viewed 1093 times since Wed, Jun 13, 2012
Event Logging - Record Deletion
Viewed 2022 times since Wed, Sep 21, 2016
Update Job Record within Enquiry
Viewed 1999 times since Tue, Jun 12, 2012
Output to Microsoft Excel 2007
Viewed 94269 times since Mon, Jun 11, 2012
Additional Options for History / Analysis Enquiries
Viewed 1842 times since Fri, Oct 26, 2012
Document Design Manager - Setting and Applying Font Defaults
Viewed 2222 times since Wed, Jun 13, 2012
Printing to PDF
Viewed 2574 times since Wed, Jun 13, 2012
Document Design Manager - Moving, Deleting and Amending Items
Viewed 2317 times since Wed, Jun 13, 2012
Landing Pages - Check for Refresh Every X Minutes
Viewed 120 times since Tue, Oct 15, 2024
Data Visualisations
Viewed 1278 times since Thu, Jun 18, 2020
|