You can perform calculations using existing values or values that will be generated in the future using these functions:
ValuesToDate: Insert to use all the values that an object has generated.
See valuesToDate
You cannot use ValuesToDate in calculations using application data such as results and scores.
timeOffset: Insert to use old values, current values, or values that will be generated in a formula.
See timeOffset
You can indicate the period of time during which values were, or will be, generated using a time interval, such as a week or month.