Hi all,
I've noticed a strange issue with a workflow where we only want to target clients with $0-$1000 total transactions of a certain type and date range.
I have created the totals using an enrichment activity and a Sum expression (Sum(@gross_amount)) which works fine.
However, when I try to query the results, I am getting $0 values in the Subset AND the Compliment
Query:
Subset:
Complement:
I also noticed that 0 values are being sorted as smaller than negative values when I sorted asc or desc.
I haven't noticed issues with querying =0 in any other situations.
Any help would be much appreciated.
Thanks
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Views
Replies
Total Likes
Here is the configuration
Sum(@gross_amount)
Please let me know if you need any other views.
Thanks
Views
Replies
Total Likes
Hello @Josh-W
Did you try directly adding sum(@gross_amount) in enrichment?
Currently it is added a child attribute by Cashflow in link?
Also, whenever we do aggregation the groupBy value is required. Try adding recipient id as groupBy parameter
Views
Replies
Total Likes
Hi @_Manoj_Kumar_
I'm unsure what you mean about directly adding sum(@gross_amount) without it being a child attribute.
Would Cashflow need to be my targeting dimension for this to be possible?
Here are my steps before creating the sum expression
For the data grouping is it simply one of these options? I tried each one but didn't see any difference in the results.
Thanks
Views
Replies
Total Likes
Views
Like
Replies