5 Replies Latest reply on Jun 13, 2019 8:44 AM by Ewald Hofman

    Minus value is incorrect

    Grace Raj

      Hi All,


      I am trying to do minus between Open value and close value for the time period.. The difference is not correct


      For Example


      Total Open Month :COUNT(DATEPART("month",[Approval Date]))

      Total Close Month :COUNT(DATEPART("month",[Closed Date]))


      Difference : Total Open Month - Total Close Month


      For January , 148-1 = 147

      For Feb- 16-3= 13


      But it is not expecting as we expected,.... It shows January -116, Feb-12,Marc :2

      Please let me know is this calculation correct or not...