7 Replies Latest reply on Apr 18, 2016 7:45 AM by Phat Luu

    Show Total of a CountD calculated field?

    Phat Luu

      I have a dataset that contains duplicates. I am unable to de-duplicate the dataset using SQL query. I used countd to get a running count of the column I need totaled.

      Is there a way to get the end value of my running count to show as a total or be displayed?

       

       

      "Case Count"  = RUNNING_COUNT(COUNTD([Case Number]) )

       

       

       

      Case Count

      1

      2

      3

      4

      5

      6

      7

      8

       

       

      I want to display the number 8.