When I display value in expression it doubled the value? Why?

[#1]

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.

-Bill here

[Sokkorn]

Hi Bill,

Try expression : sum(DISTINCT sr.qty_returned)

Also check your data source for duplicate value.

Regards,

Sokkorn

[#3]

In some parameters or query, it display correct data, so maybe it's in the datasource.

[#4]

Hi,

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.

Regards
venkat