Referencing Data in Table W/I Formula
Posted: Tue Jun 07, 2016 10:50 am
I have a calculated series and I want to reference data contained in a table in the series calculation.
Is there a way to do this?
For example, my calculated series draws a line with a slope of 0.06...
Like this: 0.06 * trend + acwi_m0.c(2)...
However, I don't want to "hard code" the 0.06 like this.
I would rather store a value in a table and reference the table. That way, if the 0.06 changes I don't have to keep updating the formula...
Or is there a better way to do this?
Thanks!
Is there a way to do this?
For example, my calculated series draws a line with a slope of 0.06...
Like this: 0.06 * trend + acwi_m0.c(2)...
However, I don't want to "hard code" the 0.06 like this.
I would rather store a value in a table and reference the table. That way, if the 0.06 changes I don't have to keep updating the formula...
Or is there a better way to do this?
Thanks!