Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I exculde the rows with null values while counting?
- Thread starter aselvan
- Start date
I suspect that you might find this much easier to do in SQL than in OLAP - using a count(jobs) where wages > 0 kinda query. Are you using MOLAP, ROLAP or HOLAP 'cos that'll make a difference too!
Let me know if you need more help.
Fi.
Let me know if you need more help.
Fi.
- Status
