Versions Compared

Old Version 6

changes.mady.by.user Unknown User (m.schadd)

Saved on

compared with

New Version 7

changes.mady.by.user Unknown User (m.schadd)

Saved on

Key

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

...

The ROUND TO MULTIPLE function rounds a number value to a specified multiple.

Syntax

Code Block
 ROUND number [UP | DOWN] TO MULTIPLE multiple
  • number - Number or attribute of some type of number to be rounded.
  • UP or DOWN - The direction of rounding. The direction DOWN points to zero for both positive and negative values, UP points away from zero. If no direction is specified, rounding will be done to the nearest multiple (half-way values will be rounded up).
  • multiple - The multiple to be rounded to. This can be both a positive and negative value of any number type.

Return types

  • number
  • integer
  • currency
  • percentage

Examples

  • ROUND 12345.23 TO MULTIPLE 500 = 12500.0000 of type number
  • ROUND 12345.23 TO MULTIPLE 5 = 12345.0000 of type number
  • ROUND 12345.23 TO MULTIPLE 0.50 = 12345.0000 of type number
  • ROUND 12345.27 TO MULTIPLE 0.50 = 12345.5000 of type number

 

Info

If you prefer a more functional syntax, you can use the ROUNDSIG, ROUNDSIGDOWN or ROUNSIGUP functions, all with 2 number parameters.

 

MULTIPLY

Use the '*' (asterisk) sign to multiply values of some type of number.

Syntax

Code Block
 number1 * number2 * ...
  • number1 - First factor; number or attribute of some type of number.
  • number2 - Second factor; number or attribute of some type of number.

Return types

  • number * number = number
  • integer * integer = number
  • currency * currency = number
  • percentage * percentage = 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. Attribute Child.pocketMoney is of type currency and has a value of 2.50. Attribute Bonus.standard is of type percentage and has a value of 5.00.

  • Child.pocketMoney * 1.00 = 2.50 of type currency
  • Child.pocketMoney * 2 = 5.00 of type currency
  • 5.00 * 3 = 15.0000 of type number
  • Bonus.standard * 5 = 25.00 of type percentage

...