Registered User
Joined: 6/5/2015
Posts: 107
|
The Sector by Year is a pre-built layout. When I open it I can see data columns for 2007, 2008,..., 2017 and YTD%Chg.
But 2018 is missing. Please help.
Thank you,
Corto
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
The way that layout is constructed it is not going to automatically add a new year as it happens.
What you would need to do is create a formula for 2018, set it to a yearly time frame, and add it as a WatchList column.
100 * (C'12/31/18' / C'12/29/17' - 1)
If you wanted this to automatically update each year instead, you could create columns for for 1 year ago (all of these need to be set to a yearly time frame as well).
100 * (C1 / C2 - 1)
Two years ago:
100 * (C2 / C3 - 1)
Three years ago:
100 * (C3 / C4 - 1)
Etc... just change the periods to match the number of years ago and create as many WatchList columns as desired.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|
Registered User
Joined: 6/5/2015
Posts: 107
|
I understand how to build it myself and succeeded to do it, but the other ones I have for 2007 ... 2017 were always there so I thought some default settings exist.
Thanks.
|
Worden Trainer
Joined: 10/7/2004
Posts: 65,138
|
No, once you have downloaded the layout it isn't going to change unless you change it.
-Bruce
Personal Criteria Formulas
TC2000 Support Articles
|