5 Replies Latest reply on Oct 24, 2018 6:19 AM by maneesh.gaddam

    Is calculated field in Column A > Column B?

    Christopher Ray

      I have a calculated field as follows:

       

      Result = sum([numerator])/sum([denominator])*100

       

      I have my data arranged in two columns: Pre and Post. There is a numerator, denominator, and calculated result for both pre and post. How can I create a variable to say "Improving" or "Not Improving" depending on whether Pre is < or > than Post?

       

      Capture.JPG