Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
COUNT(DISTINCT ODD RESULTS
Summary
count in SQL DEV different than DV ??Content
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
Version
18 , Cloud
Tagged:
0