Ranges can be used to define the list of accounts to return in your Sage Intelligence Reporting formulas, without specifically naming each account.
A range consists of two accounts where you want to retrieve data for those two accounts and every value between those two. This is indicated by using TO between your start and end value of your range. Alpha characters are also supported in an account range.
Note: You must use a space before and after TO in order to ensure clear distinction of your start and end range values.
An example could be: A to Z ;to return all values from A, A11, B2, Cetc. toZ.
Wildcards can be used in combination with account
ranges and mathematical
calculations.
Some examples of using account ranges:
Account Range | Description | Result |
200-00-00 TO 220-00-50 | Filter all accounts from 200-00-00 up to and including 220-00-50 | 200-00-00, 200-00-01 200-00-02 up to 220-00-50 |
4?00 TO 5?00 | In
a single segment range, filter accounts ranging from 4000 to 5900.
Tip: If you wanted to only include accounts ending with 00, you could create a reporting tree unit with a filter of ??00 to further filter the results. |
Sage Intelligence Reporting will determine the low end of the range which is 4000 and the high end of the range which is 5900 andreturn all accounts between the ends inclusive. 4000 up to and including 5900, which would include for example, account 4655. |
4?5-00-00 TO 4?5-03-03 | In
a multi-segment range, filter accounts with first segment ranging
from 405 up to and including 495 and second and third segments
ranging from 00-00 up to and including 03-03.
Tip: If you wanted to only include accounts with the first segment starting with a 4 and ending with a 5, you could create a reporting tree unit with a filter of 4?5-??-?? to further filter the results. |
Sage Intelligence Reporting will determine the low end of the range which is 405-00-00 and the high end of the range which is 495-03-03 and return all accounts between the ends inclusive.405-00-00 up to and including 495-03-03 which would include for example, account 406-01-02. |
An example would be when you want to retrieve an amount for all main accounts from 101 to 105. In the cell which contains the GLLink, you would type, 101 TO 105. This will give you a summarized value for accounts 101,102,103,104,105.
Tip: Use account ranges to ensure new accounts being added to the general ledger are included in your reports.