Sum case when

@r937 - to the rescue again r937… I want a single result returned rather than two separate columns, effectively putting (adding) tD and oD together to return a single result but I dig myself into a bit of a syntax hole. Originally I did have a query that returned a single result but that result always turned out to be 0 which wasn’t what I was looking for. This is part of a bigger stats query I’m working on and everything, except this bit, appears to be working fine…
Thanking you in advance for your help … yet again