5 Replies Latest reply on Nov 4, 2013 6:53 AM by Stephen Jagger

# Window average calculated field

Hi Guys,

I was wondering if this is possible.

I need to be able to average the highlighted percentages in something similar to a Total row at the bottom.

June 2012 total = avg( Jun2012 - Jan2012)

May 2012 total = avg( May2012 - Feb2012)

and so on

Steve

• ###### 1. Re: Window average calculated field

Hi Stephen,

To make sure I understand the pattern of the calculation, does the window subtract two months each subsequent year? I.e. would the April 2012 total=avg(Apr2012 - Mar2012)?

• ###### 2. Re: Window average calculated field

Hi Tracy,

not quite,

pattern is avg 6 months diagonally,

Column June 2012 Tot = Avg(4.49%,6.53%,4.2%,5.8%,5.47%,5.53%)

May Tot = Avg (41.08%,38.61%,40.43%,42.68%,42.93%,43.00%) and so on.

it's easy in excel.....

=AVERAGE(R19,S18,T17,U16,V15,W14)

Stephen

• ###### 3. Re: Window average calculated field

Many thanks to James Austin from Interworks for solving this for me.

• ###### 4. Re: Window average calculated field

Hi Stephen:

For the benefit of the forum, it would be great if you could post the solution you've found for anyone looking at a similar problem.

• ###### 5. Re: Re: Window average calculated field

Many apologies Matthew.

The main problem is that i don't understand the answer myself so i can't explain it.

but i've attached anyway.

regards

Steve