MDM Expressions:Count, Max, Min, Concat etc

[Former Member]

Hi,

Has anyone tried using the commands in the MDM expression builder ?.

This is specifically with reference to functions such as Count, Max, Min, Concat etc.

There seems to be no documentation available on the subject.

Concat doesnot even accept multiple parameters, so how could one possible

concatenate two or more strings.

Also, the aggregate functions(Max, Min, Count) donot seem to work across records.

Any pointers on the above ?

Regards,

Jeron

[Former Member · Accepted solution]

Hi Jeron,

I have used Concatenate and Substring extensively. If you want to concatenate multiple values like A,B,C,D

concat(concat(concat(a,b),c),d)

Let me know if you need more infor on these commands

Regards

Prashant

[Former Member]

The COUNT, MAX, MIN, SUM, AVERAGE and CONCAT functions are for use with multi-valued lookup fields.

The COUNT function "Counts the number of all assigned multi-valued lookup field values"

The MAX function "Returns the highest number of all assigned multi-value lookup fields (e.g Price)"

You can guess what MIN, SUM and AVERAGE return

CONCAT "Lists all assigned values of a multi-value lookup field separated by a semicolon"

If you want to concatenate strings, use "&".