This content has been marked as final.
Show 3 replies

1. Re: Help counting results within a given range
Matt Lutton Oct 29, 2013 6:52 AM (in response to Greg Cowart)Can you post a packaged workbook with some sample data in it? That will allow you to get the best help possible from the forum. Thanks!

2. Re: Re: Help counting results within a given range
Greg Cowart Oct 29, 2013 7:01 AM (in response to Matt Lutton)Here is the attached workbook. The 2 sheets in question are 381 and 382.
thanks,

blending help.twbx.zip 1.0 MB


3. Re: Re: Re: Help counting results within a given range
Matt Lutton Oct 29, 2013 7:23 AM (in response to Greg Cowart)See sheet 382 in the attached. I calculated a WINDOW_SUM of the results, with the proper compute using settings (see below), then created a SIZE() calculation which returns the # of days in the period. Then, a final calculation to divide the two.
The table calc settings for all the calcs are set up as follows:

blending help ML.twbx.zip 1.0 MB
