1 of 1 people found this helpful
Our users were running reports with invoice counts and it confused them and me as to why they would get fractional counts. I did some investigation to try to determine how Spend Visibility was calculating the count. I haven't found any documentation that defines how the calculation is done so I tried to back into it based on how the counts react to the data.
The unique combination of Invoice ID and Extra Invoice Key, appears to denotes an invoice. I couldn't determine if Invoice Number played a part because in my sample each Invoice ID was tied to only one Invoice Number.
The reason I was getting fractions was because my filter was splitting some of the invoices. That didn't seem right because my criteria was just accounting date and supplier, and I assumed that an invoice is entered all at one time for one supplier. I found that my fractional count was due to an invoice that had been originally paid in a prior time period and then reversed in the current time period. The invoice had two line items, the original and the reversal. The count showed .5 for the current time period. I also intentionally applied filters to break up invoice's to see what happened to the count and if an invoice had 10 lines and I filtered it so only one of those lines were in the report the invoice count was .10.
In excel the only thing I could suggest is to run a pivot by supplier and invoice number, then copy the results and run a second pivot against the results.
Hopefully this provides some help.