I think the only change you need to make is make the ELSE condition a NULL (zeros get counted in counts), if fact just loose the ELSE part and it will evaluate everything outside that date range to NULL anyway...or change the aggregation from COUNT to SUM (and then you can use your zeros)
Hope that does the trick, and get's you back on the logic formula-horse!!
1 of 1 people found this helpful
Thanks for your help that did the trick!