Home › Discussions › Questions & Answers › Defining Complex Segment Value Filters in Balance Function
Customer · · Questions & Answers · 7 replies
What are the accepted formats for defining inclusion and exclusion filters for segment values in the `br_balance` function?
There are four primary accepted formats: Single value (e.g., ‘1110’), Range (inclusive span using hyphen, e.g., ‘1100-1300’), and List (multiple values separated by semicolons, e.g., ‘1500;1510;1590’).
How do I define exclusions within these formats?
Exclusions are defined by using a tilde (~) prefix combined with the inclusion format, such as ‘1100-1300;~1200’.
When I use a List format, how are the segment values combined?
Lists always function as OR conditions (e.g., ‘1110;1210’ returns accounts matching either value).
Do parent values in a list automatically include their child values?
Yes, when included in a list, Parent values automatically include their hierarchies.
Sign in with LinkedIn or Google to take part.
