Expression to auto generate next child number in hierarchy (EDMCS)

Summary:

Requirement: Expression to Derive Maximum Number in Hierarchy in EDMCS

We need to create an expression in EDMCS that automatically generates the next available child number within a hierarchy, based on the maximum existing value under a given parent.

Details:

• The first three digits of the child number are determined by the property selection (e.g., 110, 120, or 130).
• Each parent node contains child members that follow a sequential numbering pattern. last 2 digit should rolling numbers based on the last max number
• When a new child is created, the expression should identify the maximum existing child number under the parent and generate the next sequential number.