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