<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="&#1;" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:"Cambria Math";
        panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:Tahoma;
        panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
        {font-family:"Brush Script MT";
        panose-1:3 6 8 2 4 4 6 7 3 4;}
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
        {margin:0cm;
        margin-bottom:.0001pt;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
        {mso-style-priority:99;
        color:blue;
        text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
        {mso-style-priority:99;
        color:purple;
        text-decoration:underline;}
span.EmailStyle17
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle18
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle19
        {mso-style-type:personal;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
span.EmailStyle20
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:#1F497D;}
.MsoChpDefault
        {mso-style-type:export-only;
        font-size:10.0pt;}
@page WordSection1
        {size:612.0pt 792.0pt;
        margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
        {page:WordSection1;}
-->
</style><!--[if gte mso 9]><xml>
 <o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
 <o:shapelayout v:ext="edit">
  <o:idmap v:ext="edit" data="1" />
 </o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-GB" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">That&#8217;s because you don&#8217;t have an a, you don&#8217;t have anything in your condition column so that column isn&#8217;t included.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">What you need to do is ensure that each column that you want actually contains values and the condition actually refers to $param.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">The simplest way to do this is make your condition basic != $param and put null in as the row values.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">I&#8217;m not clear why you have two separate rules for PF and HRA? You could just as easily do this in a single rule?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">Thomas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></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 lang="EN-US" style="font-size:10.0pt;font-family:
&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org]
<b>On Behalf Of </b>Kripa Nathwani<br>
<b>Sent:</b> 20 August 2010 10:22<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> Re: [rules-users] error while inserting values in excel<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">PFA newly modified DT and corresponding POJO as you have asked for.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">CONDITION which we have applied on
<b>basic </b>is such that I have to check &#8216;if value passed to <b>basic </b>&nbsp;variable is null(i.e. no value has been passed from calling code i.e.
<b>main</b> method pasted below). We have written such a CONDITION because we wanted that rule should fire only when some value has been
<b>set to basic variable from &nbsp;calling method </b>and also I have changed data type of basic to Integer as you had asked for.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">Calling program :<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">final</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">void</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> main(String[] args) {</span><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">try</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black"> {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#3F7F5F">// load up the knowledge base</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KnowledgeBase kbase =
<i>readKnowledgeBase</i>();</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; StatefulKnowledgeSession ksession = kbase.newStatefulKnowledgeSession();</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; KnowledgeRuntimeLogger logger = KnowledgeRuntimeLoggerFactory.<i>newFileLogger</i>(ksession,
</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#2A00FF">&quot;test&quot;</span><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">);</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#3F7F5F">// go !</span><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AmountPojo
<span style="background:silver;mso-highlight:silver">a</span> = </span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">new</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> AmountPojo();</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<span style="background:silver;mso-highlight:silver">a</span>.setBasic(1000);</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ksession.insert(<span style="background:silver;mso-highlight:silver">a</span>);</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ksession.fireAllRules();</span><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; logger.close();</span><span lang="EN-US" style="font-size:10.0pt;font-family:
&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">catch</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black"> (Throwable t) {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; t.printStackTrace();</span><span lang="EN-US" style="font-size:10.0pt;font-family:
&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">But,still we are getting &nbsp;error
<b>as &#8216;a can not be resolved&#8217;</b> and this error is occurring on lines 5(occurrence is 3 times) and 14 (occurrence is 3 times). To my surprise, I found that these rows (i.e. row no.5 and 14) are blank.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">Please suggest some solution for the same<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:14.0pt;font-family:&quot;Brush Script MT&quot;;color:black">Best Regards,<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:14.0pt;font-family:&quot;Brush Script MT&quot;;color:black">Kripa
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:
&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org]
<b>On Behalf Of </b>Swindells, Thomas<br>
<b>Sent:</b> Friday, August 20, 2010 1:55 PM<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> Re: [rules-users] error while inserting values in excel<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">You class looks totally wrong!<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">What are you using statics? These should all just be instant variables (as you are trying to get a &#8211; an instance of AmountProj).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">If you want to have nullable values then you can&#8217;t use primitives, you need to use the Object forms (java.lang.Double, java.lang.Integer).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">The syntax of your rules are wrong as well. Your should merge the a: AmountPair across all your condition columns so that you are using the same a.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">Your condition expressions are also wrong &#8211; you should be using mvel not java style code and you should be using the column value.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">This means that your expression should look like &#8220;basic == $param&#8221; (this would test that the basic salary matches whatever is in the corresponding column.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">If you just want the rule to run always as long as basic isn&#8217;t null (assuming you&#8217;ve done the fixes above) then the simplest way is to have teh expression
 &#8220;basic != $param&#8221; and then place null in the column, although I think you need to explain a bit more of what you are trying to achieve as I&#8217;m not sure why you are trying to do this in a spreadsheet?<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">Thomas<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></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 lang="EN-US" style="font-size:10.0pt;font-family:
&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org]
<b>On Behalf Of </b>Kripa Nathwani<br>
<b>Sent:</b> 20 August 2010 08:36<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> Re: [rules-users] error while inserting values in excel<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">Hi,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D">The foll is the java file which I tried to run as a stand alone application:<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:11.0pt;font-family:&quot;Calibri&quot;,&quot;sans-serif&quot;;
color:#1F497D"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">package</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> com.sample;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">class</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> AmountPojo {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">int</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#0000C0">basic</span></i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">double</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#0000C0">pf</span></i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">double</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#0000C0">hra</span></i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">int</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> getBasic() {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">return</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#0000C0">basic</span></i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">void</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> setBasic(</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">int</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
 basic) {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AmountPojo.</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#0000C0">basic</span></i><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
 = basic;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">double</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> getPf() {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">return</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#0000C0">pf</span></i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">void</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> setPf(</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">double</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
 pf) {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AmountPojo.</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#0000C0">pf</span></i><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
 = pf;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">double</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> getHra() {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">return</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#0000C0">hra</span></i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">public</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">static</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">
</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:#7F0055">void</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black"> setHra(</span><b><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#7F0055">double</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
 hra) {</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AmountPojo.</span><i><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:#0000C0">hra</span></i><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Courier New&quot;;color:black">
 = hra;</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;color:black">&nbsp;&nbsp;&nbsp; }</span><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black">}<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black">Let me know if you still require any further information.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black">Regards,<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US" style="font-size:10.0pt;font-family:&quot;Courier New&quot;;
color:black">Kripa</span><span lang="EN-US" style="font-size:11.0pt;font-family:
&quot;Calibri&quot;,&quot;sans-serif&quot;;color:#1F497D"><o:p></o:p></span></p>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:
&quot;Tahoma&quot;,&quot;sans-serif&quot;">From:</span></b><span lang="EN-US" style="font-size:10.0pt;
font-family:&quot;Tahoma&quot;,&quot;sans-serif&quot;"> rules-users-bounces@lists.jboss.org [mailto:rules-users-bounces@lists.jboss.org]
<b>On Behalf Of </b>tom ska<br>
<b>Sent:</b> Friday, August 20, 2010 12:42 PM<br>
<b>To:</b> Rules Users List<br>
<b>Subject:</b> Re: [rules-users] error while inserting values in excel<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US">Ok, please write me AmountPojo class code, and - if You can - those rules in DRL, I will try to write You rules in DT.<br>
<br>
regards,<br>
tom<o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-US">2010/8/20 Kripa Nathwani &lt;<a href="mailto:Kripa.Nathwani@lntinfotech.com">Kripa.Nathwani@lntinfotech.com</a>&gt;<o:p></o:p></span></p>
<div>
<div>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Hi,<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Below is the decision table on which I am working. It is calculating PF and HRA by taking basic value and checking that basic is not equal to null.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">The problem is when I start inserting values in the column it is giving me following error messages:<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;no viable alternative at input ')' in rule &quot;Pricing bracket_12&quot; in pattern AmountPojo<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;mismatched input '!=' expecting ')' in rule &quot;Pricing bracket_12&quot; in pattern AmountPojo<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">Unknown error while parsing. This is a bug. Please contact the Development team<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">I know it is related to syntax but I am not able to solve&nbsp; it.<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US"><img border="0" width="1037" height="1048" id="_x0000_i1057" src="cid:image001.png@01CB4053.06AFAA30"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-size:14.0pt;font-family:&quot;Brush Script MT&quot;;color:black">Best Regards,</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-size:14.0pt;font-family:&quot;Brush Script MT&quot;;color:black">Kripa</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US" style="font-size:14.0pt;font-family:&quot;Brush Script MT&quot;;color:black">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
</span><span lang="EN-US"><o:p></o:p></span></p>
<p class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><span lang="EN-US">&nbsp;<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span lang="EN-US" style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;
color:black">This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate
 the information, notify the sender and delete it from your system.<br>
</span><span lang="EN-US"><br>
______________________________________________________________________<o:p></o:p></span></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><span lang="EN-US"><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><o:p></o:p></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US"><br>
<br>
______________________________________________________________________<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span lang="EN-US" style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;
color:black">This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate
 the information, notify the sender and delete it from your system.<br>
</span><span lang="EN-US"><br>
______________________________________________________________________<o:p></o:p></span></p>
</div>
<p class="MsoNormal"><o:p>&nbsp;</o:p></p>
<div class="MsoNormal" align="center" style="text-align:center">
<hr size="2" width="100%" align="center">
</div>
<p class="MsoNormal"><span style="font-size:7.5pt;font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;
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 postmaster@nds.com 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>
</span><br>
______________________________________________________________________<o:p></o:p></p>
<p class="MsoNormal"><span lang="EN-US"><o:p>&nbsp;</o:p></span></p>
<div class="MsoNormal" align="center" style="text-align:center"><span lang="EN-US">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal"><span lang="EN-US" style="font-family:&quot;Arial&quot;,&quot;sans-serif&quot;;
color:black">This Email may contain confidential or privileged information for the intended recipient (s) If you are not the intended recipient, please do not use or disseminate
 the information, notify the sender and delete it from your system.<br>
</span><span lang="EN-US"><br>
______________________________________________________________________<o:p></o:p></span></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 postmaster@nds.com 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>
</body>
</html>