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

[manjulap9198882]

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

[pablo_rosero1 · Accepted solution]

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