5 Replies Latest reply on May 30, 2013 8:28 AM by Ira Skop

    Using CountD() in a Calculated field on a blended dataset

    Ira Skop

      I have 2 data tables I am blending - both are tableau extracts.

       

      I can create a result that shows, in one column, CNTD([StringField]) from the primary table, and in a 2nd column, SUM([Number of Records]) from the secondary table. I would like to see a ratio of the two, so I created the following calculated field:

       

      COUNTD([Primary Table].[StringField])/SUM([Secondary Table].[Number of Records])

       

      I can't get this to work. My question is: should it?