Hello,I'd like to know how to use the SetVar function avaliable in advanced expression editor.Can anyone give me a use case of this feature please ?Thanks in advance,Pierre-Yves

OK Thanks to both of you for your answers.asish kumarp59945245 : I'll find a way to perform the calculation I need without using the agregate functions on the advanced expression editor then.anasso21228396​ : I could effectively use the collections to perform agregate calculations (but i'll have to ...

Hello,The query in on profiles for example, see below.- Profile : Has children = YesAnd in additionnal Data :- Average(age)This cause an error in the query :I hope my post is detailed enough.Thanks in advance

Hello,I dont have such options, I working on Adobe Campaign Standard (ACS) and the only option avaliable is to remove duplicate rows :(The screenshot is from a french version)

Hello, I have a problem using aggregate function in ACS.When I add an additionnal data wich is based on the SUM() function in a simple query activity, I get a PostgreSQL Error : column "n1.irecipientid" must appear in the GROUP BY clause or be used in an aggregate function.I can't do any aggregate, ...