Units

The software allows Line Items and Constants to be designated as different types of units, including user defined types. Depending upon whether a FO Type parameter is a Constant or a Line Item, it can be assigned a unit type.

Units Formatting Line Item Constant Description Example
Monetary Currency X X    
Percent Percentage X X Any value entered will be converted to a decimal for calculation purposes. 100% would be converted to 1.
Annual Rate Percentage X X Any value entered will be interpreted for calculation purposes based on the timeframe of the model. 12% will be converted to 1% if the model is monthly, or 3% if the model is quarterly
Periods None X X A value defined as periods will interpreted based upon the timeframe of the model. In an Annual model, a period is one year, in a monthly model a period is one month
Days None X X Days are consistent across all model time frames and are automatically adjusted to the number of days in the calendar month and year (in a leap year, February has 29 Days).  
Other None X X    
Period Date   X A specific period February, 2012
Day Date   X

A specific day.

Can be used to display a Not Applicable Date format as defined in Model Parameters. For this, all dates beyond the year 9000 will be considered as a Not Applicable Date. 

February 14, 2012
Enumerated Type Drop Down List   X A selection list, with each item assigned a unique constant value, for use in formulas Jan has a value of 1, Feb has a value of 2, etc.. A conditional expression a mathematical expression that follows the form:if x is true, do this, otherwise that. Also known as If-Then-Else statements can be written that if the list item selected has a value of 2, to return the desired value for February.
Ratio Line Item          
User Defined None X X As specified.  

 

Creating User Defined Unit Types

  1. Navigate to Model Infrastructure/Units and Enumerated Lists.
  2. Right-click and select Add Unit.
  3. Type in a title for the units.

Once created, Line Items and Constants will be able to be defined as a unit of this type.

 

Case Dimensions

Constant

Line Item

FO Types