2 Replies Latest reply: Oct 18, 2013 2:49 PM by Dave Schadock RSS

    Wrong average between dates

      Hello!

       

      I'm desperated and very thankful for everybody who could take a look at my attachment (can find problem and explanation in here).

      In one case it is working, but the second one does not although I'm using the same method.

      I mean the sum is right, the count is right, but the average isn't...

       

      So many thanks!

        • Re: Wrong average between dates
          Clever Anjos

          Just formatting issue...

          or apply

          =interval(Sum({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDir_TimeToOwn)/

          Count({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDirect_ID))

           

          OR

           

          =(Sum({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDir_TimeToOwn)/

          Count({<TechDir_CloseDateTimestamp ={"$(=Date(addmonths(Max(TechDir_CloseDateTimestamp), -4), 'MM/YYYY'))"}, TechDir_closure_code=-{'Void'}>} TechDirect_ID) * 24