1 Reply Latest reply on Jun 21, 2013 2:17 PM by Shawn Wallwork

    Field Calculation from 2 different data sources?

    adam m

      I have 2 different data sources.  In the first data source, each row looks like...

      ID #, Name, Date, Quality, Color, [some more descriptions]

       

      In the second data source, each row looks like...

      Name, Date, Hours

       

      In the first data source, there are multiple ID #'s per Name and Date (i.e. for Name "A" and Date "Dec. 1", there can be several rows).  However in the second data source, each Name and Date combination corresponds to a single Hours entry.  Example below:
      Name     Date      Hours

      A           Dec. 1       8

      B           Dec. 1       6

      A           Dec. 2       8

       

      I would like to be able to create a table that displays COUNTD([ID #]) / SUM([Hours]) where I can filter by Name and Date.  When I put this calculation into the details pane, it turns red and no value is returned.

       

      Any suggestions?