Question

Querying when value=0 on an aggregated field is not working correctly

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Community Advisor

Could you please share screenshot of how the enrichment is configured?

Manoj Find me on LinkedIn

Here is the configuration

Sum(@gross_amount)

Please let me know if you need any other views.

Thanks

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

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

Sign up