10 Replies Latest reply on Sep 28, 2011 1:18 PM by HaroldBernstein

    Help with Unique Value script

    HaroldBernstein

      Title

      Help with Unique Value script

      Post

      I would like to calculate the number of unique integer values in Field1, but only for those records in which Field2 ≠ "Yes."

       

      I'm familiar with the unique value calculating script:

        sGroupCount=Count(Field1)

        cFraction=Get Summary(sGroupCount;Field1)

        sUniqueCount=Sum(Field1)

       

      I need some advice, however, for modifying so that I'm only counting unique fields in records which satisfy Field2≠"Yes."