QPR Knowledge Base 2016.1

Constants

Constants

Previous topic Next topic No directory for this topic  

Constants

Previous topic Next topic Topic directory requires JavaScript Mail us feedback on this topic!  

Formulas can contain the following constants:

 

Type

Format

Examples

Integer

[+|-]<n>

123, -311, +3

Floating Point

[+|-]<n>[.<n>]

0.45, -31.1, +0.1

Scientific

[+|-]<n>[.<n>]E[+|-]<n>

11E1, -1.13E3, +51E2, 0.3421E-5

Boolean

FALSE|TRUE

FALSE, TRUE

Text

"<t>"

"Lorem ipsum"

 

Used markings:



<n>

numeric value

[ ]

optional part

<t>

text value

Note that the decimal separator for the floating point and the scientific numbers is not dependent on Windows' Regional Options. The separator is always a point (".") regardless of the regional settings.

 

Note that to use a double quotation mark as a part of a text constant, you need to precede the double quotation mark with a backslash. For example, a text constant defined as "ab\"c" will have the value ab"c.

 

Scientific notation was designed for easy representation of floating point numbers that are either very large or very small. A scientific number consists of base and exponent which are separated from each other with a letter E: <base>E<exponent>. The exponent is the exponent of 10. To calculate the real value of a scientific number, use the following formula: <base>*10<exponent>.