To build a formula manually:
- Select the Formula tab.
- Select the Click 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 want to give it: 1)- 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 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. - (Optional) 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 theInfo icon false Note: The function that you chose and follow the steps provided.
...
...
Related topics:
Include Page | ||||
---|---|---|---|---|
|
...