Difference between revisions of "Advanced Ratings: Using Formulae"

From SchemeServe Help
Jump to: navigation, search
(Created page with "If you wish to make your ratings more dynamic then it's OK to use formulae in your rating files. ''We've provided a couple of example formulae here:'' Answer:Q3, Formula:[Q1_C...")
 
(See Also:)
Line 21: Line 21:
  
  
[[Introduction to Rates in SchemeServe]]
+
#[[Introduction to Rates in SchemeServe]]
 
+
#[[Uploading SchemeServe Rating Files]]
[[Uploading SchemeServe Rating Files]]
+
#[[Downloading SchemeServe Rating Files]]
 
+
#[[Flat Rating: Building Your First SchemeServe Rating File]]
[[Downloading SchemeServe Rating Files]]
+
#[[Rating Modifiers: What they are and when to use them]]
 
+
#[[Multi-Step Ratings: Using Multiple Sections in Rating Files]]
[[Flat Rating: Building Your First SchemeServe Rating File]]
+
#[[Advanced Ratings: Using Formulae]]
 
+
#[[Advanced Ratings: Conditional Statements and Functions]]
[[Rating Modifiers: What they are and when to use them]]
+
#[[Advanced Ratings: Rounding Values]]
 
+
#[[Master Rating: Using Tables and Row Lookup Loops]]
[[Multi-Step Ratings: Using Multiple Sections in Rating Files]]
+
#[[Example Ratings for Specific Insurance Types (Life and Public Liability)]]
 
+
#[[Conditions for Rating Files]]
[[Advanced Ratings: Conditional Statements and Functions]]
+
#[[Actions for Rating Files]]
 
+
#[[Mathematical Helper Functions for Ratings Files]]
[[Advanced Ratings: Rounding Values]]
+
#[[Rating Agents: Tips and Tricks]]
 
 
[[Master Rating: Using Tables and Row Lookup Loops]]
 
 
 
[[Example Ratings for Specific Insurance Types (Life and Public Liability)]]
 
 
 
[[Conditions for Rating Files]]
 
 
 
[[Actions for Rating Files]]
 
 
 
[[Mathematical Helper Functions for Ratings Files]]
 
 
 
[[Rating Agents: Tips and Tricks]]
 

Revision as of 01:50, 4 December 2012

If you wish to make your ratings more dynamic then it's OK to use formulae in your rating files.

We've provided a couple of example formulae here:


Answer:Q3, Formula:[Q1_Cover]+[Q2_Cover], SetCover:Q4 Yes, 1000-999999, [Q4_Cover]*0.2

This formula changes the rating for Q4_Cover based on a positive answer to Q3 and the results of the Formula


SetCover:Days ([DateEnd_DateValue]-[DateStart_DateValue]).Days

This formula calculates the number of days between any two given dates.


You can use any of the conditional statements and functions in a formula and it's important to pay attention to rounding values too.


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. Rating Modifiers: What they are and when to use them
  6. Multi-Step Ratings: Using Multiple Sections in Rating Files
  7. Advanced Ratings: Using Formulae
  8. Advanced Ratings: Conditional Statements and Functions
  9. Advanced Ratings: Rounding Values
  10. Master Rating: Using Tables and Row Lookup Loops
  11. Example Ratings for Specific Insurance Types (Life and Public Liability)
  12. Conditions for Rating Files
  13. Actions for Rating Files
  14. Mathematical Helper Functions for Ratings Files
  15. Rating Agents: Tips and Tricks