5 Replies Latest reply: Mar 1, 2017 11:00 AM by Sunny Talwar RSS

    Count Ids for Max Month

    Bobby Flake

      Team,

       

      I have a simple problem and can't seem to work it out.  I have a table that has [CW ID] and a month value.  The data is updated once at the beginning of the month with the previous month's data which means that from March 1 until April 1 the table will only contain data up to and including Feb and on April 1 the March data comes in.

       

      I am trying to do a count of [CW ID] but only for the mac month in the data and can't seem to get the code working.

       

       

      Suggestions?

      Examples?