2 Replies Latest reply on Aug 29, 2016 11:41 AM by Stephen Ball

    Incorrect Null values across multiple data sources

    Stephen Ball

      Quick question that I am hoping has an obvious answer. I have connected my workbook to two separate data sources with extremely similar fields. The important fields are joined and I was hoping to create a simple sum formula. The formula I currently am using works fine if data exists in each data source. But when there is a null for a particular month in one datasource, the formula returns a null value as a whole. See the following chart:

       

      Table Error.jpg

       

      Ideally, when one month returns a null in one datasource, then the total volume should be represented as the sum of the singular datasource that did have data. Any help would be appreciated! I have also included a shot of the calculated field currently being used (below).

       

      8-29-2016 1-36-01 PM.jpg