Answers/SchemeServe Answers
Answered
Table Rules
Paul Taylor
asked this on June 24, 2011 13: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
Comments
Hi Guys,
Have you had chance to look at this question?
Thanks
Paul
Hi Paul,
"Get Table Column" > "TableName" > "ColumnName" > "Greater Than" > "Limit To Fire Action on"
Thanks,
Rob.
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
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"
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
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.
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
Hey Rob, I think I know what it is!
Don't spend any time on it at the moment, thanks.
Cheers
Paul