Home Discussions Questions & Answers Defining Complex Segment Value Filters in Balance Function

Defining Complex Segment Value Filters in Balance Function

Avatar photoCustomer May 30, 2025 at 12:25 am

What are the accepted formats for defining inclusion and exclusion filters for segment values in the `br_balance` function?

Viewing 6 reply threads
  • Author
    Replies
    • Support May 30, 2025 at 3:48 am  

      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’).

    • Avatar photoCustomer June 1, 2025 at 4:55 am  

      How do I define exclusions within these formats?

    • Support June 2, 2025 at 12:01 am  

      Exclusions are defined by using a tilde (~) prefix combined with the inclusion format, such as ‘1100-1300;~1200’.

    • Avatar photoCustomer June 2, 2025 at 7:09 am  

      When I use a List format, how are the segment values combined?

    • Support June 2, 2025 at 1:27 pm  

      Lists always function as OR conditions (e.g., ‘1110;1210’ returns accounts matching either value).

    • Avatar photoCustomer June 4, 2025 at 4:58 am  

      Do parent values in a list automatically include their child values?

    • Support June 5, 2025 at 3:50 am  

      Yes, when included in a list, Parent values automatically include their hierarchies.

Viewing 6 reply threads
  • You must be logged in to reply to this post.

Login with: