1 Reply Latest reply on Oct 26, 2016 3:48 PM by Santiago Sanchez

    Issue in conditional filter logic

    Debayan Bhattacharjya

      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

       

      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

       

      Data Set

       

      Credit amountDebit amountDifference(Credit-Debit)
      1000.0001000.0000.000
      103.253102.2531.000
      225.023226.023-1.000
      231.275231.587

      -0.312