aggregation returns wrong value

[mohammadnabi]

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?

[Or]

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.