Home » Categories » Solutions by Business Process » Utilities |
Post Code Analysis |
Article Number: 394 | Rating: Unrated | Last Updated: Wed, Jun 14, 2023 at 4:19 PM
|
Datafile Software Post Code Analysis It can be useful to analyse (say) sales by post code but with the varying lengths of post codes – for example Liverpool is ‘L’, some London areas are ‘EC’, you can’t create a standard item for analysis unless you manually entered these details into a separate data item. This new feature allows you the option to create two sub-items based on the post code that will enable this analysis. The first, PC-MAIN, takes the initial letters of the post code, the second PC-BREAK, takes the first part of the post code. Example Post Code PC-MAIN PC-BREAK
CH41 5AZ CH CH41 L3 4BD L L3 EC1M 9RT EC EC1M Whichever item you require can then be used for sorting and subtotalling in your reports. Installation To use either of these options requires you create a sub-item in a database containing a post code (such as the sales accounts file). The data items need to be created with the detail below. Item Name Type Description PC-MAIN = Sub-item of the post code, starting at position 1 with a size of two characters. If the second character is a number then this is replaced with a blank. PC-BREAK = Sub-item of the post code, starting at position 1 with a size equal to the length of the post code field itself. |
Attachments
![]() There are no attachments for this article.
|
Calling a Batch Update Definition - Profiler
Viewed 1919 times since Thu, Jul 5, 2012
Data Item Access via Authority Level
Viewed 1691 times since Wed, Jun 13, 2012
Increased Options Allowed on the Main Menu
Viewed 75 times since Thu, Jan 9, 2025
Windows 10 1803 Update / Windows Defender
Viewed 2495 times since Wed, May 30, 2018
Confirm Printer - Sales/Purchase Batch Updates
Viewed 1678 times since Thu, Jul 5, 2012
Order Processing Batch Update - Import Order Reference
Viewed 1715 times since Wed, Jun 13, 2012
QR Code Image Generator
Viewed 221 times since Thu, Oct 24, 2024
System Status - Stock Batch Update
Viewed 1573 times since Thu, Jul 5, 2012
Custom Features - Job Costing Batch Update
Viewed 1756 times since Thu, Jul 5, 2012
Forecast Dates - Negative ‘Credit Terms’ Dates
Viewed 126 times since Thu, Jan 9, 2025
|