Hi I have a simple report with 2 fields named credit amount and Debit amount and there is a difference field which is the difference of two field as below.
Now I have a calculated field which I have taken as a filter and the condition is if the difference is between -1 to +1 then it will be matching data else unmatching data and I wrote the below condition
IF ([DIFFERENCE] > -1.000 and [DIFFERENCE] < 1.000) then "MATCHING_DATA" ELSE "UN MATCHING_DATA" END
But when I select UN MATCHING_DATA as filter its showing all the values . Kindly help me on this .Thnx
|Credit amount||Debit amount||Difference(Credit-Debit)|