Building a Formula Manually
To build a formula manually:
- Select the Formula tab.
- Select the Insert KBI button. 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 wish to give it: 1) Previous day's value [expressed as a negative number], 2) Current day's value [expressed as 0], or 3) 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 the Insert Operator button and choose the type of operation you want to perform.
- Click OK. The operation type is displayed in the Formula area.
- Click the Insert Function button, if appropriate, 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. Note the function that you chose and follow the steps provided.
Related topics: