Rank: Advanced Member
Groups: Registered, Registered Users
Joined: 3/23/2010(UTC)
Posts: 60
|
I have a formula that has a variable "x" calculated 8 days ago....this I know how to do.
I then want to use "x" as a constant in the formula over the last 7 days.
Here is part of the formula syntax:
If( Defined, Signalb, DerivedAvg - x)
The formula plots "DerivedAvg - x" over the last 8 days, otherwise it plots Signalb. As it stands now, the formula calculates "x" from 8-days ago and ONLY applies it to Today. I want "x" to be applied to Today AND the 7 preceding days too. So each new day, a new value of "x" is calculated and used in the formula both Today And over the past 7 Days.
Thank's,
Dennis
|
|
|
|
|
|
| Users browsing this topic |
|
Guest (Hidden)
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
