Please look at the picture, the one in dimension displays correct value, while the one in expression, doubled the value, how to fix this?
Please help. Thanks in advance.
Try expression : sum(DISTINCT sr.qty_returned)
Also check your data source for duplicate value.
In some parameters or query, it display correct data, so maybe it's in the datasource.
Yes most of the cases for occuring multiple values is having problem with when creating the datasource .
I too also faced such kind of problem after lots of test case i came to know that the data in the datasource itself having the mutliple values.
Retrieving data ...