Custom Validation Rule for Additional Assignment Info

Hi All,

we are working for a customer which requires additional EFF for the Assignment information.

The EFF are 1:n cardinality with the Assignment Record. Basically they need to record the list of the assignment cost centers and the distribution. In practice the assignment has cost center A and cost center B all of them have a cost allocation distribution which mans that the sum of each distribution for each cost center must be equal to 100%.

I've tired to define a validation rule in VB Studio but seems that does not work, there is no way to validate the sum of the records in EFF data structure, basically if the sum of all distribution is not equal to 100, then raise an error.