COUNT(DISTINCT ODD RESULTS
Summarycount in SQL DEV different than DV ??
We are tying to validate our reports. We get different numbers when we run My Calculations "COUNT(DISTINCT VOUCHER_ID)" in DV TILE versus "COUNT(DISTINCT VOUCHER_ID)"Oracle SQL Developer.
Both use the same SQL (pulled SQL from DV paste into SQL Dev), same ADW.
I have refreshed the Dataset more than once today. DV is processing this dataset differently than SQL Dev. How? I have lost
count 318 in DV
count 550 in SQL DEV