Validations for sum value

[Former Member]

Hey,

I have a problem with validations:

I have in a product repository a multi-valued qualified lookup into an 'ingredients' table.

In the 'ingredients' table I have several ingredients and as qualifier the percentage of its share in the product.

So now I want to make a validation in the 'product' main table checking if the sum of all ingredients' percentages is 100%.

I haven't found a sum formula though, yet.

Can anyone help, please?

Thanks,

Chris

[Former Member · Accepted solution]

Hi Christiane,

It is not possible to sum up this in MDM as of now.

Regards

Vinay

[AndreasSeifried]

Hi Christiane,

I do not know a solution for that using SP03, but SP04 will have aggregation functions. You can apply these functions e.g. to the non-qualifier fields in order to sum them up. The bad news is, that you will have to wait until August....

Kind regards

Andreas

[Former Member]

Thank you both!

I guess I'll have to wait for SP4 then.

Thanks,

Chris