Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
i have a problem with set analysis syntax, this :
MaxString({<Année={2016},[Numéro de prospectus]={$(=subfield(concat( {<Année={2016}>}DISTINCT [Numéro de prospectus],';'),';',2))}>}[Libellé de prospectus])
doesn't work.
Do you have some idea ?
Thanks
Sophie
What is the problem? You see no data? Is there any error in the object? Is it a text object or a table?
Two things I can think of without more background:
MaxString({<Année={2016},[Numéro de prospectus]={"$(=subfield(concat( {<Année={2016}>}DISTINCT [Numéro de prospectus],';'),';',2))"}>}[Libellé de prospectus])
EDIT: Set to double quotes because of the use of single quotes already in the functions.