Category

General-Purpose Functions

Description

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

Syntax

Top(value, digits)

Parameters

value - the number to get top digits from

digits - the count of digits to get

Notes

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