Forum Discussion

Easley06's avatar
Easley06
Icon for Helper II rankHelper II
3 years ago

running 12 weeks

Hi,

 

is there a way to compute this 

Total Corporate = 48 

Formula : Total Corporate / Average( first 3 weeks in the running 12(weeks) )

 

 

 

thanks.

2 Replies

  • johnt75's avatar
    johnt75
    Icon for Super User rankSuper User
    3 years ago

    Have a look at the WINDOW function, you should be able to do an AVERAGEX over that.

  • FreemanZ's avatar
    FreemanZ
    Icon for Super User rankSuper User
    3 years ago

    not so sure about the request. could you elaborate it?