Advanced Ratings: Rounding Values

From SchemeServe Help
Jump to: navigation, search

Introduction

This area of SchemeServe is more complex than most others.

In order for you to make the most out of using our Help Guide for developing your own rates, it would be best if you read all the parts of this guide in order.

To help you with this they are listed in numerical order in the “See Also” section of each page.

You can click on a link to take you to section 1 and then move through logically at your own pace.

Rounding Values

There are a number of ways of rounding results in SchemeServe, the recommended methods are to use the CEILING function which rounds up and the FLOOR function which rounds down.

It's important to define where the decimal point lands for accurate rounding.

E.g. 101 round up to 200 = CEILING(101/100.0) * 100 = CEILING(1.01) * 100

You can also use the expression Round(number, decimals).

However it is important to understand that the default behaviour of this expression in SchemeServe is to round to the nearest even number.

That means 1.5 and 2.5 both round to two.

The reason for this is that because most numbers tend to be positive rounding away from zero (the standard form of rounding) is statistically less acccurate than rounding to an even number.

If you are looking for financially accurate rounding use RoundUp(number, decimals) as it will always round .5 up.

e.g To round the TotalPremium result:

0DP = RoundUp([TotalPremium_Result], 0)
1DP = RoundUp([TotalPremium_Result], 1)
2DP = RoundUp([TotalPremium_Result], 2)

It's important to fully understand all the options for rounding before calculating ratings for use in SchemeServe otherwise the answers to your expressions may not be as you would assume.

See Also:

  1. Introduction to Rates in SchemeServe
  2. Uploading SchemeServe Rating Files
  3. Downloading SchemeServe Rating Files
  4. Flat Rating: Building Your First SchemeServe Rating File
  5. Conditions for Rating Files
  6. Actions for Rating Files
  7. Rating Modifiers: What they are and when to use them
  8. Multi-Step Ratings: Using Multiple Sections in Rating Files
  9. Advanced Ratings: Using Formulae
  10. Advanced Ratings: Conditional Statements and Functions
  11. Advanced Ratings: Rounding Values
  12. Master Rating: Using Tables and Row Lookup Loops
  13. Example Ratings for Specific Insurance Types (Life and Public Liability)
  14. Mathematical Helper Functions for Ratings Files
  15. Rating Agents: Tips and Tricks