3 Replies Latest reply on Oct 29, 2013 7:01 AM by Greg Cowart

Help counting results within a given range

Hello,

I'm looking for some help in finding the number of results within a given range.  I'm using the below formula to find which days performace was between .50 and .90.  I built a table but it wont produce a total across rows because it is a calculated field and I cant seem to do a sum because it is already aggregated.

IF [Calc-Service Level] >.90 THEN 0 ELSEIF [Calc-Service Level] <.50 THEN 0 ELSE 1 END

Ideally what i would like to do see is a % of the days where the result was 1 so i would need to sum the results and divide by the number of days in the period.

Any thoughts?

Thanks,

• 1. Re: Help counting results within a given range

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

Here is the attached workbook.  The 2 sheets in question are 381 and 382.

thanks,

• 3. Re: Re: Re: Help counting results within a given range

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: 