Many numbers used in computations are not easy to remember. As an example, whole books are written to calculate the value of PI to one million decimal places.
CFL uses names to represent these constant values. These constant names can be used in a formula anywhere a number can be used. CFL will automatically replace the constant with its appropriate value.
Built-In Constants
Constant | Value | Description | |||
FALSE | 0 | The Boolean value for FALSE | |||
LN2 | 2.71828… | The natural log constant | |||
NO | 0 | The Boolean value for FALSE | |||
NoDate | 0 | The system value used when no date is entered | |||
OneDay | 1 | One Day of Time in a DateTime Type | |||
OneHour | 1/24 | One Hour of Time in a DateTime Type | |||
OneMinute | 1/(24*60) | One Minute of Time in a DateTime Type | |||
OneSecond | 1/(24*60*60) | One Second of Time in a DateTime Type | |||
PI | 3.14159… | The ratio of a circle to its diameter | |||
TODAY | Current Date/Time | This (pseudo) constant returns the current date and time in a DateTime Type | |||
TRUE | 1 | The Boolean value for TRUE | |||
YES | 1 | The Boolean value for TRUE |
Store-Wide Constants
Constant | Returns the value setup in pricing setup as the default multiplier for… | ||
DefaultEquipmentMultiplier | Equipment | ||
DefaultFreightMultiplier | Freight | ||
DefaultLaborMultiplier | Labor parts | ||
DefaultMaterialMultiplier | Materials | ||
DefaultOtherMultiplier | Other parts | ||
DefaultOutsourceMultiplier | Outsourced items | ||
DefaultOverheadMultiplier | Overhead |
This value is normally multiplied by the outsourced costs to determine their price.
User-Defined Global Constants
CFL allows the user to create custom built-in constants. All these global constants are accessible from CFL. It is common to preface a constant with “gc” as in the following examples. This is not necessary, but helps to jog the memory a few months later.
Const gcBoilingPoint 212 ; Const gcSubstance "Water" ; Const gcFreezingPoint 32 ; Const gcAluminumCost 1.25 per SqFeet ; Const gcLaborRate 20 per Hour ; Const gcPromotionEndDate #12/31/2007#
Global Constants can have units or be unit-less. They can be strings, numbers, or dates. They are also infrequently used for items that vary. Once a global constant has been created, it can be used in any formula as shown in the following examples:
AlumCost : Quantity * Area * gcAluminumCost ; LaborCost : Quantity * LaborPerPiece * gcLaborRate ;
A few rules apply to creating global constants and variables.
- A global constant and a variable cannot have the same name.
- A text constant must be less than 50 characters.
- Global constants must follow the same naming convention as variables.
See Also