Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Bill,
Try expression : sum(DISTINCT sr.qty_returned)
Also check your data source for duplicate value.
Regards,
Sokkorn
In some parameters or query, it display correct data, so maybe it's in the datasource.
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