To build a formula manually:
- Select the Formula tab.
- Click Insert KBI.
The Insert KBI dialog box appears. - Choose a KBI from the KBIs list.
- Enter a value for the Days to offset.
Once you have selected a KBI, there are three choices for the value you want to give it:- Previous day's value [expressed as a negative number],
- Current day's value [expressed as 0],
- Future day's value [expressed as positive numbers 1,2,3 etc.].
- Click OK.
The KBI number is displayed in the Insert KBI area. - Click Insert Operator and choose the type of operation you want to perform.
- Click OK.
The operation type is displayed in the Formula area. - (Optional) Click Insert Function and choose a function.
- Click OK.
Proceed to Entering Formulas for a list of the functions and the steps you will take to complete the formula.
Related topics: