Query Builder
- Add – Period Formatting options for both filtering and outputting periods. Previously periods where always formatting using the year and period number e.g., 2022/009. Now it is possible use Month names assuming there are 12 periods in a year. The Financial Year Start can also be specified to allow the mapping of period 1 to the correct month. For example, UK has an April start so 2022/001 can be displayed as 2021/22 April while Australia uses July as period 1 so 2022/001 becomes 2021/22 July. There are over 35 formats supported and just like the previous period formats offsets can be added to these to calculate periods e.g. 2022/005 -1p oys or 2021/22 Nov -1p oys. There are formats to show either the Calendar Year CA and also the Financial Year FA depending on what users find easier to work with. Generally, none financial users related to Calendar years and months better than to Financial Years.
Filter Options
Output Options
Studio
- Add – Schema / Import Field Remove List. Use to bulk remove tables fields based on a CSV formatting list