Expand my Community achievements bar.

We are excited to introduce our latest innovation to enhance the Adobe Campaign user experience — the Adobe Campaign v8 Web User Interface!
SOLVED

How to get sum of last 2 purchase amount of each customer in ACS

Avatar

Level 1

Hi,

I have linked the profile schema with transactional custom schema by using customer ID field in Adobe Campaign Standard. Now i want to pull customers whose last 2 bills total amount is greater than $1000. By using collection option (in additional data section in query) i am able to fetch the last 2 transactional records. But aggregate function is not working on collection data. Could you please help me to achieve the same.

 

Thanks,

Manju

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi @manjulap9198882,

 

Sorry for the delay in responding. I'm not entirely sure but if you're using Aggregate then follow these instructions on and after number 3. Make sure it's numerical and the data is correctly set.

 

https://docs.adobe.com/content/help/en/campaign-standard/using/managing-processes-and-data/targeting... 

 

Hope this helps!

Pablo

View solution in original post

1 Reply

Avatar

Correct answer by
Level 10

Hi @manjulap9198882,

 

Sorry for the delay in responding. I'm not entirely sure but if you're using Aggregate then follow these instructions on and after number 3. Make sure it's numerical and the data is correctly set.

 

https://docs.adobe.com/content/help/en/campaign-standard/using/managing-processes-and-data/targeting... 

 

Hope this helps!

Pablo