EXPANDSEGMENTVALUERANGE Function
Created by Harry Lewis, Modified on Tue, 16 Jul at 9:33 AM by Gabriel Michaud
Applies to:
- Velixo Classic
- Velixo NX
- ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Acumatica
The EXPANDSEGMENTVALUERANGE function returns all segment values matching the specified key ID, segment number, and range expression.
TABLE OF CONTENTS
Syntax
EXPANDSEGMENTVALUERANGE(ConnectionName, SegmentedKeyName, SegmentId, Range, IncludeDescription)Parameters
The EXPANDSEGMENTVALUERANGE function uses the following parameters:
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager. |
| SegmentedKeyName | Required | The segmented key name for which to filter segments. |
| SegmentId | Required | The segment number for which to filter segments. |
| Range | Optional | The Velixo range* specifying which matching segments to include in the results. If left blank, every matching segment will be included in the results. |
| IncludeDescription | Optional | True or False (default) Determines if each returned segment's description should be included in the results. |
* see Filtering Techniques for Velixo Functions
Example
Given the following configuration within the ERP:
Example 1 - show segment values
=EXPANDSEGMENTVALUERANGE("Demo", "SUBACCOUNT", 1)Description
Returns an Excel array of all possible values for the first segment of the SUBACCOUNT key ID
Result
Example 2 - show segment values and descriptions
=EXPANDSEGMENTVALUERANGE("Demo", "SUBACCOUNT", 2,,TRUE)Description
Returns an Excel array of all possible values for the second segment of the SUBACCOUNT key ID and include the description of each segment.
Result
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article