Oh, thank you, yes I see the extra condition (now). Thank you also for the link. I definitely need to study that.

Again, thanks so much for your help!

You're right. The last line is incorrect. I shouldn't have included it. If it said 4 4 0, it would be correct.

I had it the way you have it without...

Thanks. I'll need to work on this.

Hi Dan,

The average would be of the last three month totals. For example, in July, I would need the average of May, June and July.

Thanks for your note. What I am trying to get is all rows from the dbo.ndw_account_dim a table that meet the where clause (I only put in a few accounts...

Yes, these both work perfectly. Thank you so much!! 😀

The decimal is 9.

Yes, I did try that. I'm not clear on where exactly it goes in the query and the exact syntax.