Overview
Each observation in series has a number which can be used as a reference. These numbers are calculated for each document starting from 0. You can check the observation number with Counter() or Counter(series) formula. You can use this formula as a placeholder for series
To output value based on the observation number use At(series, observation number). The most popular way to indicate observation number is Date(YYYY, MM, DD) formula.
See All about counting observations page for more ideas.
Show values
Show value for a specific observation
Use At() with Date(), Start() and End() to show value of the specific observation.
Date() and At() - pointing to a point
Show value one month back
Show always value one month before end of series.
AddMonths() and At() - value one month back
Show value for every (second) Friday
Show value for EndOfWeek() in a Daily series.
Show value for every (second) Friday
Remove observations
Cut observations from the middle
Remove observations using Date().
Cut observations from the middle
Cut series at the end of previous month then extend
Always remove last value and replace it with extension.
