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

      etc..

      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...

       

      Thanks

      Grace