5 Replies Latest reply: Jul 20, 2012 8:06 AM by Sam Sansome RSS

    Sum across a date range

    Sam Sansome

      I am really struggling with this one.

       

      Basically I need to have a new KPI to show the distance travelled to fulfil invoices in a given date range

       

      To do this I have linked the Location Distance to Invoice Date.

       

      But when I use a simple SUM(IF(INVOICEDATE>=FromDate and INVOICEDATE<=ToDate,LocationDistance)) calculation then some of the figures are increasing relative to the number of lines on the invoice.

       

      Please see attached with sample data in to see if you can help.

       

      I'm guessing that it is something simple but I just can't see it.

       

      Looking forward to your assistance....

       

      Sam