0 Replies Latest reply: Jun 27, 2018 7:30 AM by Del Booth RSS

    Multiple master calendars and two tables not joined

    Del Booth

      Hi.

       

      I have two tables one an orders table that has 3 master calendars - date entered,date scheduled and date collected.  I have a separate table that lists dispatches for which i have generated master calendar for dispatches.  The two tables can be plotted as graphs independently but if i want to combine the tables to get:

      Tonnes dispatched for a month with tonnes collected for the same month and tonnes entered in the same month.

       

      I have tried using an if statement  =sum(if(CollectMonth=DispatchMonth and DispatchYear='2018',[Quantity Collected],Null())) to try and link the numbers form two master calendars.

       

      Thanks

      Del