I am trying to pass a number (Ex: 6000) as job parameter and use that parameter in the stage variable. But the job parameter is acting weired. Below are the complete details.
I added a job parameter with name AmtDiff with value as 6001. My logic int he stage variable is
StageVariable : svDiffAmt
Code: Select all
If lkp.NOTFOUND then 1 else if ((lnlink.AMOUNT- lkp.AMOUNT) <> 0 and (lnlink.AMOUNT- lkp.AMOUNT) > AmtDiff ) then 1 else 0
In the result I am getting the negative values as well. When I used the function like > Num(AmtDiff) I am not getting the negative values but there are some positive values in the file that are less than the parameter value (6000).
Any help would be appreciated.