UCE and data editing

Use UCE to automate data editing. For example, if you are missing data and you want to fill in the missing data with the values for the same days in a previous year, use the following UCE formula to perform this calculation:

$spc[-364da]

$spc is a UCE token that references "the channel that we are currently calculating." It only makes sense for a stored formula or interval channel in the context of editing or validation.

Inside the brackets, the formula subtracts 364 days (one year) from the current value. The result is the same value from the same day of the previous year.