Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
COUNT(DISTINCT ODD RESULTS — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

COUNT(DISTINCT ODD RESULTS

Accepted answer
24
Views
2
Comments
edited Sep 11, 2019 5:22AM in Oracle Analytics 2 comments

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:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!