EXPANDSEGMENTVALUERANGE Function

Created by Harry Lewis, Modified on Thu, 04 Jan 2024 at 04:17 PM by Harry Lewis

Applies to:

  • Velixo NX
  • ERP: Acumatica, CEGID, Haufe x360, JAMIS Prime, MYOB Advanced


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.

SegmentedKeyNameRequiredThe segmented key name for which to filter segments.
SegmentIdRequiredThe segment number for which to filter segments.
RangeOptionalThe Velixo range* specifying which matching segments to include in the results.
If left blank, every matching segment will be included in the results.
IncludeDescriptionOptionalTrue
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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article