Hi there...my first reply in here (my first day in here period!)...:-)
Without doing a quick test, I would think that you would use a "sum distinct(decode....." in a derived field for each check date.
I'm not sure where exactly you are going, but am thinking you are heading something like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.