Registered User Joined: 10/7/2004 Posts: 17
|
Hello,
At the top of the "Sector by Year" layout there are three rows of years, from 2004 to 2015. I imagine that the is done by adding a column with certain criteria and then renaming the column to the year (if the data is available). Can we do this ourselves and, if so, how do we do it?
TIA
|
Worden Trainer
Joined: 10/7/2004 Posts: 65,138
|
Try using the following Indicator Fomula for your WatchList Column. While it would probably work right now in a daily time frame, you will probably want to set it to a yearly time frame instead to make sure it keeps working in the future.
100 * (C'12/30/2016' / C'12/31/2015' - 1)
You will also probably want to edit the WatchList Column so you can change the Header to 2016, Positive Color to green, and Negative Color to red under Properties for the WatchList Column./p>
-Bruce Personal Criteria Formulas TC2000 Support Articles
|