The error you get is due to the second condition (application: Application()) not being included in the generated rules. Empty cell means: the column's snippet is not included in the rule. <br><br>Since you don't have a constraint for Application() you can employ a trick: remove the column and prefix the text application: Application() to the text in cell C7.<br>
<br>In Rule 1, do you really want to test whether a payment is not greater than zero?<br><br>Do you realize that Rules 2 and 3 would both fire for certain payment amounts?<br><br>You can update a String field. To concatenate, use<br>
x.setString( x.getString() + "whatever" );<br><br>-W<br><br><div class="gmail_quote">On 9 September 2011 14:08, john@oa <span dir="ltr"><<a href="mailto:john@openaspect.co.uk">john@openaspect.co.uk</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Guvnor: guvnor-5.2.0.Final-tomcat-6.0<br>
<br>
Hi<br>
<br>
I am a Drools Newbie and I have an integer field called score that I need to<br>
add to when a rule matches in a spreadsheet decision table. i.e. the score<br>
field should hold a running total of all scores that are matched. However,<br>
I can't even update the field in the table. I have attached the spreadsheet<br>
for review. In this spreadsheet I am simply trying to set the score, and<br>
that is failing with:<br>
<br>
DScoringTable] Rule Compilation error application cannot be resolved<br>
<br>
My goal is to have different decision tables that will all need to update<br>
the same score, and keep a running total of the total score.<br>
<br>
Any help very much appreciated! I hope that I am just missing something<br>
obvious.<br>
<a href="http://drools.46999.n3.nabble.com/file/n3322713/demo-score-sheet.xls%0Ademo-score-sheet.xls" target="_blank">http://drools.46999.n3.nabble.com/file/n3322713/demo-score-sheet.xls<br>
demo-score-sheet.xls</a><br>
<br>
In future I may wish to also update a String field and keep concatenating to<br>
that field, is this possible?<br>
<br>
John<br>
<font color="#888888"><br>
<br>
--<br>
View this message in context: <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322713.html" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322713.html</a><br>
Sent from the Drools: User forum mailing list archive at Nabble.com.<br>
_______________________________________________<br>
rules-users mailing list<br>
<a href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/rules-users" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</font></blockquote></div><br>