Resetting Running Total On First Of Year

Discussion created by laguna92651 on Oct 3, 2017
Latest reply on Oct 4, 2017 by laguna92651

I have a list of totals, I am trying to do a summary total, Run Tot, that restarts on January of the next year, 1/1/2018,, in this example the Run Tot would reset to 20..

Running Total.jpg

I've tried breaking up the date list with TOs that are defined with date interval relationships, but can't get the data back together to plot. Looking for simplest approach.

I was planning to plot the Run Tot values with the List() function and a delimited data source.