1 Reply Latest reply on Oct 26, 2018 9:00 AM by Deepak Rai

    How can I add the total for two fields (from different data sources) even if one of them is Null?

    Chadi Atie

      Hello Guys,

       

      I have this table in the screenshot below:

       

       

      The 1st Number of Records field is coming from Data Source "A"

      The 2nd Number of Records field is coming from Data Source "B"

      The Total Entries is a calculated field equal to this: SUM([Number of Records])+SUM([(Data Source "B")].[Number of Records])

       

      As you can see, the Total Entries is showing me the Aggregation just when there is values in the two data sources (i.e month of July). Otherwise, it is not showing the total of April, May, June, Aug.

       

      Is there a way to make the Total Entries appear even when I don't have data from the 2nd Number of Records (Data Source "B")?

       

      Thanks a lot for your help,

       

      Chadi