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

Community Advisor

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

Manoj Find me on LinkedIn

Sign up