david.jack (10/27/2016)
Hmmmm... it doesn't work in my scenario but, as per your assessment, the formula does seem to be correct, so my results must be the product of joins/grouping I guess. I'll investigate further with that in mind. Thank you for the feedback. Really helpful 😀
You are very welcome.
😎
Quick question, do you have ANSI_WARNINGS on? Are you getting any ANSI NULL warnings like Null value is eliminated by an aggregate or other SET operation?