aggregation returns wrong value

mohammadnabi — Tue, 26 Oct 2021 18:47:54 GMT

hi guys,

we have faced an issue regarding one report that we try to create.

we are using below aggregation:

SUM( {$<CANCEL_STATUS={0},SUBMITTED_ON={'T'}>}
if(aggr(sum({$<CANCEL_STATUS ={0},SUBMITTED_ON={'T'}>}SALES_QUANTITY),VISIT_DATE,EMPLOYEE_REF,CUSTOMER_REF,PRODUCT_FAMILY)>=0.5,SALES_QUANTITY))

as on the photo you can see, and according to formula, "drop size" should return the same value as "FF sales", but it is not. any idea on how to manage the problem?

Re: aggregation returns wrong value

Or — Tue, 26 Oct 2021 18:55:07 GMT

I think you'll have to share some sample data and additional information here - your aggr() uses a field that's not in your screen capture, and we have no way of knowing what you're actually summing up and how it interacts with your formula, or what other formula you're using as a basis for comparison.

topic aggregation returns wrong value in Connectivity & Data Prep

aggregation returns wrong value

Re: aggregation returns wrong value