# Difference between revisions of "Advanced Ratings: Using Formulae"

From SchemeServe Help

(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 20:50, 3 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:

- 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: Using Formulae
- 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