8 Replies Latest reply: Dec 6, 2017 5:16 AM by Anil Babu RSS

    Sum for entire month

    Mervin Govender

      I hope someone can help. I need to calculate a sum of target for the entire month selected.

       

      This is my load of the target table

       

      Targets:

      LOAD targetID,

           clientID,

           super_categoryID,

           ext_campaignname,

           target,

           Date(workingday,'YYYY/MM/DD')as Date

       

      And my calendar

      Calendar:

      LOAD Date(Date,'YYYY/MM/DD') as Date,