3 Replies Latest reply on May 9, 2018 10:00 PM by Saurav Vasudev

    Error While Applying IF Condition

    Saurav Vasudev

      This is my data table :

      Ques.PNG

      I have to do the following operation : Whenever the Debug count is more than 26, the message(Filename) is successful else it is not.

      I am writing the following query : IF ATTR([LogLevel])=="DEBUG" AND COUNT([Number of Records])>26 THEN"Success" ELSE"Fail"end

      I am getting the following result in which the last row splits into two :

       

      Ques1.PNG

      This is not the output which I  was expecting. How should I modify the query to get the correct result.