Other Name Range Function (FSN.Range.OtherNames)
Other Name Range Function (FSN.Range.OtherNames)
The FSN.Range.OtherNames function returns a dynamic array that can be used to quickly build out worksheets that segment data based upon the other name. This is a specific type of Entity. Note that roll-up values will only show if the parent/child relationship are both other name type entities. The full parent/child hiearchy is viewable by using the full Entity function instead.
The syntax for the function is:
| Argument Name | Input Information | Required | Default Value |
|---|---|---|---|
| Include Filter | Specifies the other names to include. Multiple values can be specified by another dynamic array (e.g., using a named range, specifying a range of cells like E1:E10, etc) or concatenated as a string using the ^ character. Additionally, if the values are numeric wildcards and range values can be used such as 100-200, 10*, or 1*-20?0. | No | Include all other names |
| Exclude Filter | Specifies the other names to exclude. Values can be specified as they are in the Include Filter | No | Exclude none |
| Subsidiary | Specifies the subsidiary to use to determine the other names to return. Only other names that are valid for the subsidiary are returned. | No | Does not filter by subsidiary |
| Include Blank | Determines whether or not to include the <No Other Name> explicit blank value in the list | No | TRUE |
| Level | Specifies the maximum level of the hierarchy to return. A value of 2 will return all levels <= 2 | Includes all levels | |
| Include Inactive | Specifies whether or not to return other names marked as IsInactive=T in NetSuite | FALSE (Excludes inactive) | |
| Include Rollup | Include rollup value (Hierarchy) for values with children | TRUE (parent rollup Hierarchy values are returned) | |
| Rollup Only | If TRUE, then only top-level rollup values are returned | No | FALSE |
| Horizontal | Controls whether the returned dynamic array spills vertically or horizontally. This values is useful when creating reports based on other names, where values are specified in a single row across the sheet. | No | FALSE (returns a vertical list) |
| Rollup First | When TRUE, returns the rollup (Hierarchy) values before the children. When false, the rollup value is returned after the children | No | TRUE (Rollup value is returned first) |
Remarks
- Review the Function filter syntax for selecting ranges as needed.
- #SPILL! may appear in the array function cell when the resulting array determined by your parameters will not fit in the provided Excel area.