15 Replies Latest reply: Feb 17, 2017 11:17 AM by Jack Hertel RSS

    Apply value to every row in table

    Crystle Stamper

      I have master list of customers. I then have a table that is linked to this table by a key field with a Fiscal Quarter and a Sales field.

       

      The problem is, that the second table doesn't have a value for the Sales for each Quarter, for each customer. I need Sales to have a value and not be null in this table for each Quarter, but I'm not sure how to accomplish this.

       

       

      So say I have 100 customers. Then I have 4 Quarters for the year.

      I should have 400 records. Each customer should have a value, to show for each Quarter, for the Sales, even if that value is 0.

       

      CustomerQuarterSales
      Customer11 (instead of null)0    (instead of null)
      Customer1267
      Customer1352
      Customer1423

       

      I have tried just creating a table with the master list and having a 0 for the Sales field and then Concatenating that to the second table but I don't think that is giving me the results I want.

       

      Any help would be greatly appreciated.