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

[Josh-W]

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

[_Manoj_Kumar_]

Hello @Josh-W 

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

[Josh-W]

Hi @_Manoj_Kumar_ 

Here is the configuration

Sum(@gross_amount)

Please let me know if you need any other views.

Thanks

[_Manoj_Kumar_]

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

[Josh-W]

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