Forum Discussion

mork's avatar
mork
Helper V
10 years ago

Group By month

Hello all, I have a table of my Resources work per week that I'm trying to group by month. How can I do that? Example table bellow.     ResourceName                   Week#                 WeekSt...
Need Help
mork's avatar
mork
Helper V
10 years ago

mondinelli I tried both your ways and only the first worked but I don't want that format... I prefer the format of the second way that doesn't work.

Anonymous's avatar
Anonymous
Not applicable
10 years ago

mork which is the error while trying the second way?

  • mork's avatar
    mork
    Helper V
    10 years ago

    It doesn't show an error, it just creates the column with the word error in every cell.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Mmm it's strange. First of all, you have problems with the "WeekStartDate", which is the format of that column? Because in my example dataset I've no problems.

      With the formula I've posted I get something like this : 1-2016

      You can also try to create two separate custom column, one with Date.Month() and one with Date.Year() and then merge them together.

       

       

      • mork's avatar
        mork
        Helper V
        10 years ago

        The formula you provided worked. I just hadn't noticed that post and I was replying to your previous one about the error I was recieving. The WeekStartDate is type date