Page History

Versions Compared

Key

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

...

Panel

bgColor	white

POWER

Use the '**' operator to raise a number to a power.

Syntax

Code Block
base ** exponent

base - Base; number or attribute of some type of number.
exponent - Exponent, power; number or attribute of some type of number.

Return types

number ** number = number
integer ** integer = number
number ** integer = number
integer ** number = number
currency ** number = currency
currency ** integer = currency
percentage ** number = percentage
percentage ** integer = percentage

Examples

Suppose the following data model.

Entitiy.attribute	Value	Type
Child.pocketMoney	2.50	Currency
Bonus.standard	5.00	Percentage

Expression	Result	Type
Child.pocketMoney ** 1.00	2.50	Currency
Child.pocketMoney ** 2	6.25	Currency
5.00 ** 3	125.0000	Number
Bonus.standard ** 5	3125.00	Percentage

Include Page

	_nav_BackToTop
	_nav_BackToTop

Panel

bgColor	white

LOG

Since 12.8

Use the 'LOG' function to calculate the logarithm of a number to a base.

Syntax

Code Block
LOG([number], [base])

number- Number; number or attribute of some type of number.
base - Base; number or attribute of some type of number.

Return types

number

Examples

Expression	Result	Type
LOG(100, 10)	2.0	Number
LOG(32, 2)	5.0	Number
LOG(3, 9)	0.5	Number

Include Page

	_nav_BackToTop
	_nav_BackToTop

...