Aggregation With IF inside showing different values in DEV and PROD

[QlikGuy1]

Here is the Expression for a Field:
Sum (Aggr (If (Condition A, 0, Sum([Price]), Key, ProductName, Date, ProductType ) )


I am getting 2 different Dev and Prod dashboard values for this aggregation with the same data. Am I breaking some rule of aggregation? There seems to be nothing wrong with the data at all.

[rubenmarin]

Hi, that's a sowmewhat standar use of aggr, so same data should return the same value. My guess is that something is different in the adta loaded by both apps, maybe ther are duplicated lines or some table is adding additional values on some of the fields used.

You can try with a simple table with Key, ProductName, Date, ProductType as dimensions and "If (Condition A, 0, Sum([Price])" as expression to try to catch the dimensions with different values.

[anat]

as told by @rubenmarin ,seems data issue,can you recheck your data in DEV and PROD