Platinum Customer
Joined: 7/3/2007 Posts: 27
|
How would I write weekly formulas for these daily formulas?
((STOC3.2 >= AVG(STOC3.2,2)) AND (STOC3.2.1 < AVG(STOC3.2.1,2))) OR ((STOC3.2 < AVG(STOC3.2,2) ) AND (STOC3.2.1 > AVG(STOC3.2.1,2)))
STOC3.2 - AVG(STOC3.2,2)
STOC3.2
AVG(STOC3.2,2)
STOC3.2 - AVG(STOC3.2,2)
Thanks!
|
Administration
Joined: 9/30/2004 Posts: 9,187
|
Try this:
((STOC15.2 >= AVG(STOC15.2,2)) AND (STOC15.2.1 < AVG(STOC15.2.1,2))) OR ((STOC15.2 < AVG(STOC15.2,2) ) AND (STOC15.2.1 > AVG(STOC15.2.1,2)))
STOC15.2 - AVG(STOC15.2,2)
STOC15.2
AVG(STOC15.2,2)
STOC15.2 - AVG(STOC15.2,2)
Note: In version 16, all you have to do is use the original formulas and set the time frame on each condition to Weekly. Much easier.
|
Platinum Customer
Joined: 7/3/2007 Posts: 27
|
Thank you so much!!!!
|