Advanced Ratings: Using Formulae

From SchemeServe Help
Revision as of 05:24, 3 December 2012 by Nickk (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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:

Introduction to Rates in SchemeServe

Uploading SchemeServe Rating Files

Downloading SchemeServe Rating Files

Flat Rating: Building Your First SchemeServe Rating File

Rating Modifiers: What they are and when to use them

Multi-Step Ratings: Using Multiple Sections in Rating Files

Advanced Ratings: Conditional Statements and Functions

Advanced Ratings: Rounding Values

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