General-Purpose Functions


Use the top N digits of a number to make a new number


Top(value, digits)


value - the number to get top digits from

digits - the count of digits to get


This function was added to make it easier to use different levels of the TRBC industry codes, though it can be used with any numeric value.

The TRBC codes are 10-digit numbers from which every pair of digits going from left to right makes the industry designation more specific.

For the economic sector code, use Top(TRBC, 2).

For the business sector code, use Top(TRBC, 4).

For the industry group code, use Top(TRBC, 6).

For the specific industry code, use Top(TRBC, 8).




Copyright © 2020-2024 Systematic Solutions, LLC