With this option a column selection can be filled by extending the first value of the selection using a trending function. A target level can be provided to indicate either a maximum or minimum for trending output. The coefficient value will define how fast the trending function will converge to the target value. Trending can be applied to multiple selected columns at the same time.
In order for trending function to succeed the first value of a selected column may not be empty.
- Select one or more columns and right mouse click for edit options to appear.
- Select the option 'Trend to value' to make the trending dialog appear.
- Enter the 'Coefficient' and optionally 'Target'. If the target is omitted it will default to 0 when trending down or infinity when trending up.
- Press 'OK' for the calculations to start. This will fill the rest of the selection. Press 'Apply' to save changes.
