Table Rules

Follow

Paul Taylor

24 June 2011 12:19

Hi Guys,

Hopefully a simple one - I want to include an endorsement within th rule builder where an entry in a table exceeds a specific value.

 

How do I do that please?

 

Thanks

Paul

0

• 

  Paul Taylor 26 June 2011 10:32

  Hi Guys,

  Have you had chance to look at this question?

  Thanks

  Paul

  0

  Comment actions Permalink
• 

  Rob Symonds 27 June 2011 11:20

  Hi Paul,

  "Get Table Column" > "TableName" > "ColumnName" > "Greater Than" > "Limit To Fire Action on"

  Thanks,

  Rob.

  0

  Comment actions Permalink
• 

  Paul Taylor 27 June 2011 11:31

  Thanks Rob.

  However, in your coding, I need to replace "Limit To Fire Action on" (which I assumed you meant me to put a constant value into), with another question.

  Can I do that?

  Cheers

  Paul

  0

  Comment actions Permalink
• 

  Rob Symonds 27 June 2011 11:51

  Hi,

  You can't do that in the rule builder.

  You'll need to add a hidden question like "CoverOverLimit"

  Then in the Rate File:

  ###
  SetCover: CoverOverLimit
  IF([TableName_ColumnName_Cover] > [QuestionToUseAsLimit_Cover], "Yes", [CoverOverLimit_Value])
  ###

  Then in the Rule Builder:

  "Get Answer" > "CoverOverLimit" > "Equal To" > "Yes"

  
  

  0

  Comment actions Permalink
• 

  Paul Taylor 27 June 2011 12:09

  Hi Rob

  Thanks again!

  In your answer, the field I want to use as the "QuestionToUseAsLimit_Cover" isn't a cover, just a standard money field. Do I still need to add "_Cover" to the field?

  Cheers

  Paul

  0

  Comment actions Permalink
• 

  Rob Symonds 27 June 2011 12:16

  Hi Paul,

  Yep, using _Cover will convert the value to a decimal in the formula, if you don't use that it may treat it as a string (say, if it's blank) so will fail.

  Rob.

  0

  Comment actions Permalink
• 

  Paul Taylor 27 June 2011 12:35

  Thanks Rob.

  I've just implemented the Minimum Premium and the CoverOverLimit fixes.I've then ran a quote through to test but it has failed with the familiar message:

  "

  It seems there was a problem carrying out your last request.

  The SchemeServe support team have been notified and will currently be looking into the problem.

   

  Could you have a look and let me know where I've gon wrong please Rob, thanks!

   

  Cheers

  Paul

  0

  Comment actions Permalink
• 

  Paul Taylor 27 June 2011 12:43

  Hey Rob, I think I know what it is!

  Don't spend any time on it at the moment, thanks.

  Cheers

  Paul

  0

  Comment actions Permalink

Please sign in to leave a comment.