6 Replies Latest reply on Jul 14, 2016 5:15 PM by Li Zhang

    calculate numbers of newly opened jobs month to date

    Li Zhang

      Hi all,

       

      I am trying to calculate numbers of newly opened jobs MTD. I used the following formulas but it didn't return any result:

       

      IF ATTR(YEAR([Date Created]))=YEAR(TODAY()) AND ATTR(month([Date Created])=MONTH(TODAY())) THEN COUNTD([Job Code]) END

       

      I have also tried the following and they all worked.

       

      IF YEAR([Date Created])=YEAR(TODAY()) AND month([Date Created])=MONTH(TODAY()) THEN [Labour Cost] END

       

      IF ATTR(YEAR([Date Created]))=YEAR(TODAY()) AND ATTR(month([Date Created]))=MONTH(TODAY())

      THEN "new job opened" END

       

      Now I am scratching my head and confused.

       

      Hope someone can help!!

       

      Thanks