<div bgcolor="#FFFFFF" text="#000000">
    Great, tried that and it works.  Now I just need to get my head round how to create rule-flows! so that I can have a chained version of rule-sets being executed in order.  Agenda Groups or Rule Flow groups that is the question, I better get reading : )<br>

    <br>
    On 12/09/2011 12:14, Swindells, Thomas [via Drools] wrote:
    <blockquote type="cite">
      
      
      
      <div>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">I’ve
            no idea why I said xml rather than drl – still too early in
            the morning.<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">It
            should be there in the documentation, you use $1 and $2
            (etc). But in this case why do you want to it’s easier for
            people to insert the values into two separate columns.<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">You
            want something like the following<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
        <table style="width:516.0pt;border-collapse:collapse" border="0" cellpadding="0" cellspacing="0" width="688">
          <tbody>
            <tr style="min-height:15.0pt">
              <td style="width:290.0pt;border:solid windowtext 1.0pt;background:#4F81BD;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="387">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:white">NAME<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border:solid windowtext 1.0pt;border-left:none;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">CONDITION<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border:solid windowtext 1.0pt;border-left:none;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">CONDITION<u></u><u></u></span></p>
              </td>
            </tr>
            <tr style="min-height:15.0pt">
              <td style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;background:#4F81BD;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="387">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:white"> <u></u><u></u></span></p>
              </td>
              <td colspan="2" style="width:226.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="301">

                <p class="MsoNormal" style="text-align:center" align="center"><span style="font-size:11.0pt;color:black">f
                    : Fact<u></u><u></u></span></p>
              </td>
            </tr>
            <tr style="min-height:15.0pt">
              <td style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;background:#4F81BD;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="387">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:white"> <u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">

                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">value
                    &gt; $param<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#95B3D7;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">

                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">Value
                    &lt;= $param<u></u><u></u></span></p>
              </td>
            </tr>
            <tr style="min-height:15.0pt">
              <td style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;background:#B8CCE4;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="387">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">Rule
                    Name<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#B8CCE4;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">

                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">Payment
                    More than<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;background:#B8CCE4;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">

                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">Payment
                    max<u></u><u></u></span></p>
              </td>
            </tr>
            <tr style="min-height:15.0pt">
              <td style="width:290.0pt;border:solid windowtext 1.0pt;border-top:none;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="387">
                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">rule<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">

                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">1<u></u><u></u></span></p>
              </td>
              <td style="width:113.0pt;border-top:none;border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt;padding:0cm 5.4pt 0cm 5.4pt;min-height:15.0pt" nowrap valign="top" width="151">

                <p class="MsoNormal"><span style="font-size:11.0pt;color:black">1500<u></u><u></u></span></p>
              </td>
            </tr>
          </tbody>
        </table>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">This
            also has the benefit you can add catchall rules for the top
            and bottom by leaving the appropriate column empty  - eg
            payment &lt;= 0, or payment &gt; 20000<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thomas<u></u><u></u></span></p>
        <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"><u></u> <u></u></span></p>
        <div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
          <div>
            <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
              <p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt">
                  <a href="http://user/SendEmail.jtp?type=node&amp;node=3329369&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden
                    email]</a> [mailto:<a href="http://user/SendEmail.jtp?type=node&amp;node=3329369&amp;i=1" rel="nofollow" link="external" target="_blank">[hidden
                    email]</a>]
                  <b>On Behalf Of </b>john@oa<br>
                  <b>Sent:</b> 12 September 2011 11:12<br>
                  <b>To:</b> <a href="http://user/SendEmail.jtp?type=node&amp;node=3329369&amp;i=2" rel="nofollow" link="external" target="_blank">[hidden
                    email]</a><br>
                  <b>Subject:</b> Re: [rules-users] Spreadsheet: Rule
                  Compilation error (xxx) cannot be resolved: Keeping
                  running total<u></u><u></u></span></p>
            </div>
          </div>
          <p class="MsoNormal"><u></u> <u></u></p>
          <p class="MsoNormal" style="margin-bottom:12.0pt">Ah Okay,<br>
            <br>
            That kind of makes sense, although I can&#39;t seem to find any
            documentation on how to merge the condition column, i.e. to
            have to parameters in one column:  Tried this to no avail
            (using the , as the implicit AND)<u></u><u></u></p>
          <table style="width:277.5pt" border="0" cellpadding="0" cellspacing="0" width="370">
            <tbody>
              <tr style="min-height:15.0pt">
                <td style="width:278.0pt;padding:0cm 0cm 0cm 0cm;min-height:15.0pt" width="371">
                  <p class="MsoNormal">Payment<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">value &gt; $param1, value &lt;=
                    $param2<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">Payment In Range<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"><br>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">0, 1500<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">1500, 2000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">2000, 3000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">3000, 4000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">4000, 5000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">5000, 10000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">10000, 15000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">15000, 20000<u></u><u></u></p>
                </td>
              </tr>
              <tr style="min-height:15.0pt">
                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                  <p class="MsoNormal">20000<u></u><u></u></p>
                </td>
              </tr>
            </tbody>
          </table>
          <p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
          <div>
            <p class="MsoNormal">On Mon, Sep 12, 2011 at 8:21 AM,
              Swindells, Thomas [via Drools] &lt;<a href="http://user/SendEmail.jtp?type=node&amp;node=3329292&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden
                email]</a>&gt; wrote:<u></u><u></u></p>
            <div>
              <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">If you dump out
                  the xml it converts the spreadsheet to you can see
                  what the resulting DRL is.</span><u></u><u></u></p>
              <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Mantis is right
                  in what the output is – if you don’t merge the
                  condition column you’ll get a drl as below (If there
                  exists a Condition (c1) such that its payment &gt;
                  $param(1) AND there exists a Condition (c2) such that
                  its payment &lt;= $param(2).</span><u></u><u></u></p>
              <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">If you merge
                  the condition column the constraints apply to the same
                  Condition object with the comma being the implicit and
                  (if there exists a Condition c1 such that its payment
                  &gt; $param(1) AND its payment &lt;= $param(2).</span><u></u><u></u></p>
              <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p>
              <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D">Thomas</span><u></u><u></u></p>
              <p class="MsoNormal"><span style="font-size:11.0pt;color:#1F497D"> </span><u></u><u></u></p>
              <div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
                <div>
                  <div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
                    <p class="MsoNormal"><b><span style="font-size:10.0pt">From:</span></b><span style="font-size:10.0pt">
                        <a href="http://user/SendEmail.jtp?type=node&amp;node=3328970&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden
                          email]</a> [mailto:<a href="http://user/SendEmail.jtp?type=node&amp;node=3328970&amp;i=1" rel="nofollow" link="external" target="_blank">[hidden
                          email]</a>]
                        <b>On Behalf Of </b>john@oa<br>
                        <b>Sent:</b> 09 September 2011 16:28<br>
                        <b>To:</b> <a href="http://user/SendEmail.jtp?type=node&amp;node=3328970&amp;i=2" rel="nofollow" link="external" target="_blank">
                          [hidden email]</a><br>
                        <b>Subject:</b> Re: [rules-users] Spreadsheet:
                        Rule Compilation error (xxx) cannot be resolved:
                        Keeping running total</span><u></u><u></u></p>
                  </div>
                </div>
                <div>
                  <p class="MsoNormal"> <u></u><u></u></p>
                  <p class="MsoNormal" style="margin-bottom:12.0pt">Thanks
                    Manstis<br>
                    <br>
                    Actually I found that the issue was caused by me
                    having incorrectly placed the &quot;RuleTable&quot; statement
                    in the spreadsheet, I believe the CONDITION&#39;s in the
                    columns are by default: AND joined.<u></u><u></u></p>
                </div>
                <div>
                  <div>
                    <div>
                      <p class="MsoNormal">On
                        Fri, Sep 9, 2011 at 3:57 PM, manstis [via
                        Drools] &lt;<a href="http://user/SendEmail.jtp?type=node&amp;node=3323194&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden
                          email]</a>&gt; wrote:<u></u><u></u></p>
                      <p class="MsoNormal" style="margin-bottom:12.0pt">Does
                        your &quot;Condition&quot; span the two columns with the
                        payment $param? e.g.<br>
                         <br>
                        <span style="font-family:&quot;Courier New&quot;">|            
                          Condition              | <br>
                          |-----------------+------------------|<br>
                          |payment &gt; $param | payment &lt;= $param|<br>
                          |-----------------+------------------|</span><br>
                        <br>
                        Otherwise you are creating rules that check the
                        following:-<br>
                        <br>
                        <span style="font-family:&quot;Courier New&quot;">when<br>
                          Condition(payment &gt; )<br>
                          then<br>
                          ...<br>
                          <br>
                          when<br>
                          Condition(payment &gt; 1000)<br>
                          then<br>
                          ...<br>
                        </span><br>
                        Whereas you really require:-<br>
                        <br>
                        <span style="font-family:&quot;Courier New&quot;">when<br>
                          Condition(payment &gt;0, payment &lt;= 1000)<br>
                          then<br>
                          ...</span><br>
                        <br>
                        etc<u></u><u></u></p>
                      <div>
                        <p class="MsoNormal">2011/9/9
                          john@oa &lt;<a href="http://user/SendEmail.jtp?type=node&amp;node=3323110&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>&gt;<u></u><u></u></p>
                        <div>
                          <p class="MsoNormal" style="margin-bottom:12.0pt">Thanks
                            Iaune<br>
                            <br>
                            That is really helpful.  Yes, I need the
                            ranges to be mutually exclusive, what is the
                            easiest way to do that?  Feel a bit cheeky
                            asking another question, but you seem to
                            know what you are talking about! I have
                            tried adding two conditions to enforce the
                            range, but that doesn&#39;t seem to work - see
                            below.  I still get multiple rules firing. 
                            Also can you recommend any good resources
                            for learning all of this, apart from the
                            online documentation?  Would you know if any
                            of the Drools books are any good?<u></u><u></u></p>
                          <table style="width:321.0pt" border="0" cellpadding="0" cellspacing="0" width="428">
                            <tbody>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="width:161.0pt;padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt" width="215">
                                  <p class="MsoNormal">payment
                                    &gt; $param<u></u><u></u></p>
                                </td>
                                <td style="width:161.0pt;padding:0cm 0cm 0cm 0cm;min-height:15.0pt" width="215">
                                  <p class="MsoNormal">payment
                                    &lt;= $param<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
                                  <p class="MsoNormal">Payment
                                    Greater Than<u></u><u></u></p>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                                  <p class="MsoNormal">Payment
                                    Less Than or Equal To<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"><br>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                                  <p class="MsoNormal">0<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
                                  <p class="MsoNormal">0<u></u><u></u></p>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                                  <p class="MsoNormal">1500<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
                                  <p class="MsoNormal">1500<u></u><u></u></p>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                                  <p class="MsoNormal">2000<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
                                  <p class="MsoNormal">2000<u></u><u></u></p>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                                  <p class="MsoNormal">3000<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt">
                                  <p class="MsoNormal">3000<u></u><u></u></p>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt">
                                  <p class="MsoNormal">4000<u></u><u></u></p>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"><br>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"><br>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"><br>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"><br>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"><br>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"><br>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"><br>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"><br>
                                </td>
                              </tr>
                              <tr style="min-height:15.0pt;min-height:15.0pt">
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt;min-height:15.0pt"><br>
                                </td>
                                <td style="padding:0cm 0cm 0cm 0cm;min-height:15.0pt"><br>
                                </td>
                              </tr>
                            </tbody>
                          </table>
                          <p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
                        </div>
                        <div>
                          <div>
                            <div>
                              <div>
                                <p class="MsoNormal">On
                                  Fri, Sep 9, 2011 at 2:22 PM, laune
                                  [via Drools] &lt;<a href="http://user/SendEmail.jtp?type=node&amp;node=3323074&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>&gt;
                                  wrote:<u></u><u></u></p>
                              </div>
                              <blockquote style="border-left:2px solid #CCCCCC;padding:0 1em">
                                <div>
                                  <p class="MsoNormal" style="margin-bottom:12.0pt">The
                                    error you get is due to the second
                                    condition (application:
                                    Application()) not being included in
                                    the generated rules. Empty cell
                                    means: the column&#39;s snippet is not
                                    included in the rule. <br>
                                    <br>
                                    Since you don&#39;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() +
                                    &quot;whatever&quot; );<br>
                                    <br>
                                    -W<u></u><u></u></p>
                                </div>
                                <div>
                                  <div>
                                    <p class="MsoNormal">On
                                      9 September 2011 14:08, john@oa
                                      &lt;<a href="http://user/SendEmail.jtp?type=node&amp;node=3322896&amp;i=0" rel="nofollow" link="external" target="_blank">[hidden email]</a>&gt;
                                      wrote:<u></u><u></u></p>
                                  </div>
                                  <blockquote style="border-left:2px solid #CCCCCC;padding:0 1em">
                                    <div>
                                      <p class="MsoNormal">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&#39;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" rel="nofollow" link="external" 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<u></u><u></u></p>
                                    </div>
                                    <div>
                                      <p class="MsoNormal"><span style="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" rel="nofollow" link="external" 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</span><u></u><u></u></p>
                                    </div>
                                    <p class="MsoNormal"><span style="color:#888888"><a href="http://user/SendEmail.jtp?type=node&amp;node=3322896&amp;i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a></span><u></u><u></u></p>

                                    <div>
                                      <p class="MsoNormal"><span style="color:#888888"><br>
                                          <a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a></span><u></u><u></u></p>

                                    </div>
                                  </blockquote>
                                </div>
                                <p class="MsoNormal"><br>
                                  <br>
                                  _______________________________________________
                                  <br>
                                  rules-users mailing list <br>
                                  <a href="http://user/SendEmail.jtp?type=node&amp;node=3322896&amp;i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
                                  <u></u><u></u></p>
                                <div>
                                  <p class="MsoNormal" style="margin-bottom:12.0pt"><a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><u></u><u></u></p>

                                </div>
                                <div class="MsoNormal" style="text-align:center" align="center">
                                  <hr style="color:#CCCCCC" noshade align="center" size="1" width="100%">
                                </div>
                                <div>
                                  <div>
                                    <p class="MsoNormal"><b><span style="font-size:9.0pt;color:#444444">If you reply to this email, your
                                          message will be added to the
                                          discussion below:</span></b><u></u><u></u></p>
                                  </div>
                                  <p class="MsoNormal"><span style="font-size:9.0pt;color:#444444"><a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322896.html" rel="nofollow" link="external" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3322896.html</a>
                                    </span><u></u><u></u></p>
                                </div>
                                <div style="margin-top:4.8pt">
                                  <p class="MsoNormal"><span style="font-size:8.5pt;color:#666666">To unsubscribe from Spreadsheet:
                                      Rule Compilation error (xxx)
                                      cannot be resolved: Keeping
                                      running total, click here.
                                    </span><u></u><u></u></p>
                                </div>
                              </blockquote>
                            </div>
                            <p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
                          </div>
                        </div>
                        <div>
                          <div class="MsoNormal">
                            <hr style="width:225.0pt" align="left" size="2" width="300">
                          </div>
                        </div>
                        <p class="MsoNormal">View
                          this message in context:
                          <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323074.html" rel="nofollow" link="external" target="_blank">
                            Re: [rules-users] Spreadsheet: Rule
                            Compilation error (xxx) cannot be resolved:
                            Keeping running total</a><u></u><u></u></p>
                        <div>
                          <div>
                            <div>
                              <p class="MsoNormal"><br>
                                Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html" rel="nofollow" link="external" target="_blank">
                                  Drools: User forum mailing list
                                  archive</a> at Nabble.com.<u></u><u></u></p>
                            </div>
                          </div>
                          <p class="MsoNormal" style="margin-bottom:12.0pt"><br>
_______________________________________________<br>
                            rules-users mailing list<br>
                            <a href="http://user/SendEmail.jtp?type=node&amp;node=3323110&amp;i=1" rel="nofollow" link="external" target="_blank">[hidden email]</a><br>
                            <a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><u></u><u></u></p>
                        </div>
                      </div>
                      <div>
                        <p class="MsoNormal" style="margin-bottom:12.0pt"><br>
                          <br>
                          _______________________________________________
                          <br>
                          rules-users mailing list <br>
                          <a href="http://user/SendEmail.jtp?type=node&amp;node=3323110&amp;i=2" rel="nofollow" link="external" target="_blank">[hidden email]</a>
                          <br>
                          <a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><u></u><u></u></p>
                        <div class="MsoNormal" style="text-align:center" align="center">
                          <hr style="color:#CCCCCC" noshade align="center" size="1" width="100%">
                        </div>
                      </div>
                      <div>
                        <div>
                          <div>
                            <p class="MsoNormal"><b><span style="font-size:9.0pt;color:#444444">If
                                  you reply to this email, your message
                                  will be added to the discussion below:</span></b><u></u><u></u></p>
                          </div>
                        </div>
                        <p class="MsoNormal"><span style="font-size:9.0pt;color:#444444"><a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323110.html" rel="nofollow" link="external" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323110.html</a>
                          </span><u></u><u></u></p>
                      </div>
                      <div>
                        <div>
                          <div style="margin-top:4.8pt">
                            <p class="MsoNormal"><span style="font-size:8.5pt;color:#666666">To
                                unsubscribe from Spreadsheet: Rule
                                Compilation error (xxx) cannot be
                                resolved: Keeping running total, click
                                here.
                              </span><u></u><u></u></p>
                          </div>
                        </div>
                      </div>
                    </div>
                    <p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
                    <div>
                      <div class="MsoNormal">
                        <hr style="width:225.0pt" align="left" size="2" width="300">
                      </div>
                    </div>
                    <p class="MsoNormal">View
                      this message in context:
                      <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3323194.html" rel="nofollow" link="external" target="_blank">
                        Re: [rules-users] Spreadsheet: Rule Compilation
                        error (xxx) cannot be resolved: Keeping running
                        total</a><br>
                      Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html" rel="nofollow" link="external" target="_blank">
                        Drools: User forum mailing list archive</a> at
                      Nabble.com.<u></u><u></u></p>
                  </div>
                </div>
              </div>
            </div>
            <p class="MsoNormal"><u></u> <u></u></p>
            <div class="MsoNormal" style="text-align:center" align="center">
              <hr align="center" size="2" width="100%">
            </div>
            <p class="MsoNormal"><span style="font-size:7.5pt;color:gray"><br>
**************************************************************************************<br>
                This message is confidential and intended only for the
                addressee. If you have received this message in error,
                please immediately notify the
                <a href="http://user/SendEmail.jtp?type=node&amp;node=3328970&amp;i=3" rel="nofollow" link="external" target="_blank">[hidden
                  email]</a> and delete it from your system as well as
                any copies. The content of e-mails as well as traffic
                data may be monitored by NDS for employment and security
                purposes. To protect the environment please do not print
                this e-mail unless necessary.<br>
                <br>
                NDS Limited. Registered Office: One London Road,
                Staines, Middlesex, TW18 4EX, United Kingdom. A company
                registered in England and Wales. Registered no. 3080780.
                VAT no. GB 603 8808 40-00<br>
**************************************************************************************</span><u></u><u></u></p>
            <div>
              <p class="MsoNormal" style="margin-bottom:12.0pt"><br>
                _______________________________________________ <br>
                rules-users mailing list <br>
                <a href="http://user/SendEmail.jtp?type=node&amp;node=3328970&amp;i=4" rel="nofollow" link="external" target="_blank">[hidden
                  email]</a>
                <br>
                <a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
                <br>
                <u></u><u></u></p>
              <div class="MsoNormal" style="text-align:center" align="center">
                <hr style="color:#CCCCCC" noshade align="center" size="1" width="100%">
              </div>
            </div>
            <div>
              <div>
                <div>
                  <p class="MsoNormal"><b><span style="font-size:9.0pt;color:#444444">If
                        you reply to this email, your message will be
                        added to the discussion below:<u></u><u></u></span></b></p>
                </div>
              </div>
              <p class="MsoNormal"><span style="font-size:9.0pt;color:#444444"><a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3328970.html" rel="nofollow" link="external" target="_blank">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3328970.html</a>
                  <u></u><u></u></span></p>
            </div>
            <div>
              <div>
                <div style="margin-top:4.8pt">
                  <p class="MsoNormal"><span style="font-size:8.5pt;color:#666666">To
                      unsubscribe from Spreadsheet: Rule Compilation
                      error (xxx) cannot be resolved: Keeping running
                      total,
                      <a rel="nofollow" link="external" target="_top">click here</a>. <u></u><u></u></span></p>
                </div>
              </div>
            </div>
          </div>
          <p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
          <div class="MsoNormal">
            <hr style="width:225.0pt" align="left" size="2" width="300">
          </div>
          <p class="MsoNormal">View this message in context: <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3329292.html" rel="nofollow" link="external" target="_blank">
              Re: [rules-users] Spreadsheet: Rule Compilation error
              (xxx) cannot be resolved: Keeping running total</a><br>
            Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html" rel="nofollow" link="external" target="_blank">
              Drools: User forum mailing list archive</a> at Nabble.com.<u></u><u></u></p>
        </div>
      </div>
      <br>
      <hr>
      <font face="Arial" color="Gray" size="1"><br>
**************************************************************************************<br>
        This message is confidential and intended only for the
        addressee. If you have received this message in error, please
        immediately notify the <a href="http://user/SendEmail.jtp?type=node&amp;node=3329369&amp;i=3" rel="nofollow" link="external" target="_blank">[hidden email]</a>
        and delete it from your system as well as any copies. The
        content of e-mails as well as traffic data may be monitored by
        NDS for employment and security purposes. To protect the
        environment please do not print this e-mail unless necessary.<br>
        <br>
        NDS Limited. Registered Office: One London Road, Staines,
        Middlesex, TW18 4EX, United Kingdom. A company registered in
        England and Wales. Registered no. 3080780. VAT no. GB 603 8808
        40-00<br>
**************************************************************************************<br>
      </font>
      <br>
      _______________________________________________
      <br>
      rules-users mailing list
      <br>
      <a href="http://user/SendEmail.jtp?type=node&amp;node=3329369&amp;i=4" rel="nofollow" link="external" target="_blank">[hidden email]</a>
      <br>
      <a href="https://lists.jboss.org/mailman/listinfo/rules-users" rel="nofollow" link="external" target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
      <br>
      <br>
      <hr noshade color="#cccccc" size="1">
      <div style="color:#444;font:12px tahoma,geneva,helvetica,arial,sans-serif">
        <div style="font-weight:bold">If you reply to this email, your
          message will be added to the discussion below:</div>
        <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3329369.html" target="_blank" rel="nofollow" link="external">http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3329369.html</a>
      </div>
      <div style="color:#666;font:11px tahoma,geneva,helvetica,arial,sans-serif;margin-top:.4em"> To
        unsubscribe from Spreadsheet: Rule Compilation error (xxx)
        cannot be resolved: Keeping running total, <a href="" target="_blank" rel="nofollow" link="external">click
          here</a>. </div>
    </blockquote>
    <br>
  </div>


        
<br/><hr align="left" width="300" />
View this message in context: <a href="http://drools.46999.n3.nabble.com/Spreadsheet-Rule-Compilation-error-xxx-cannot-be-resolved-Keeping-running-total-tp3322713p3329909.html">Re: [rules-users] Spreadsheet: Rule Compilation error (xxx) cannot be resolved: Keeping running total</a><br/>
Sent from the <a href="http://drools.46999.n3.nabble.com/Drools-User-forum-f47000.html">Drools: User forum mailing list archive</a> at Nabble.com.<br/>