Versions Compared

Old Version 3

changes.mady.by.user Julie Leake (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user Frank Gambino

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

About Entering Formulas

When you select Calculated from the Type drop-down list in the General tab, the Formula tab containing the formula building buttons become available. The formula builders are context sensitive features that let you build formulas for calculated KBIs. You can manually create a formula by using the Insert KBI, Insert Operator and Insert Function buttons, or you can use the Formula Builder button. The Formula Builder button is a combination of the other three function buttons and walks you through a logical progression of steps. Once you have become familiar with the syntax of creating calculated KBIs, you can manually enter the formula directly into the Formula field.  

Terms and Definitions

Insert KBI

Allows you to build

Build your formula by choosing KBIs from a list.

  • Anchor
    offset
    offset
    Days to offset
. Once
  • —Once you have selected a KBI, there are three choices for the value you
wish
  • want 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.]

Insert Operator

Allows you to enter

Enter the type of operation you

wish

want to perform:

  • addition
,
  • subtraction
,
  • multiplication
,
  • division
, or
  • modulo (divide and return the remainder).

Insert Function

Allows you to choose

Choose from a pre-defined set of functions. Depending on the function you choose, you will get different dialog boxes.

Formula Builder

Assists you in creating formulas using a logical progression of steps.  This button is context sensitive based on the cursor position in the formula edit box. The Formula Builder works best when creating new formulas rather than editing existing formulas.

  • A KBI Value
. Allows you to choose
  • —Choose a KBI to insert into the formula.
  • A Special Function
. Allows you to choose
  • —Choose a function to insert into the formula.
  • Numeric Constant
. Allows you to use
  • —Use a specific number in the calculation.

Clear

Clears the formula

field and allows you

field  to start over.

Note that his

Info
iconfalse

Note: This function clears the whole field, not just a portion of the formula.

 

...



...

Related topics:

Include Page
TOC-Forecast Structure
TOC-Forecast Structure

...