Formula tabs of the KBI Set Config section in Forecast Structure

Build your formula by choosing KBIs from a list. The fields in the resulting dialog box include:

• Search—Search for a KBI.

• Table—Table of available KBIs:

  • KBI Name—Name of the KBI.

  • Code—Unique identification code associated with the KBI.

  • Item In Use—Whether the KBI is in use. Check marks appear next to KBIs (including nested KBIs) that have already been included in the current formula. This indicator prevents you from unintentionally duplicating the use of a KBI in a formula.

    Note: An information icon ( ) with a tooltip indicates whether KBIs are already included with the same Days Offset in the current formula.

• 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, and so on].

Enter the type of operation you want to perform:

• Addition ( + )

• Subtraction  ( − )

• Multiplication  ( * )

• Division  ( ⁄ )

• Modulo ( % ) (divide and return the remainder)

Choose from a predefined set of functions. Depending on the function you choose, different dialog boxes appear.

Opens a wizard that guides you through the steps of building a formula. The Formula Builder works best when creating new formulas rather than editing existing formulas.

• A KBI Value—Choose a KBI to insert into the formula.

• A Special Function—Choose a function to insert into the formula.

• Numeric Constant—Use a specific number in the calculation.

Note:Unifocus recommends using the Formula Builder to create formulas. Using the Formula Builder will ensure that you are using the correct syntax.

Clears the formula field to start over.

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

Displays the complete, editable formula that you build using the buttons. You can manually edit the formula in this field.