Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

pierre-yvesm520
Community profile pierre-yvesm520 Level 2
Job title here
Location here
7 BADGES
Level 2

Level 2

Learn more
Joined the community 28-11-2017 2:15:18 AM
Offline
Top badges earned by pierre-yvesm520
Customize the badges you want to showcase on your profile
How to use the SetVar function ?
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard
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

Views

560

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard
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 adapt my workflow before)

Views

2.0K

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard

Views

1.9K

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard

Views

1.9K

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard
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

Views

1.9K

Likes

0

Replies

0
Re: Problem with aggregate function in ACS
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard
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)

Views

1.9K

Likes

0

Replies

0
Problem with aggregate function in ACS
Avatar
Give Back 5
Level 2
pierre-yvesm520
Level 2

Likes

3 likes

Total Posts

7 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
Validate 1
View profile
pierre-yvesm520
- Adobe Campaign Standard
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, could you help me please.Thanks

Views

4.3K

Likes

3

Replies

11