u/drinianrose

KPI not matching detail - tried refreshing

KPI not matching detail - tried refreshing

Hi All -

I've got one user who lives and dies by his KPI's. The problem we're having is that his KPI numbers are often out of date and/or just wrong.

As an example, here is what he sees as his receivables:

Even after refreshing the widget and/or a control-F5 in the browser, his current Receivables is listed at $194,627.

However, if we drill down on the Receivables, the summary shows this:

While it showed $194,627 in the KPI, the actual A/R Aging Summary is showing $262,075.68. If we drill down into the A/R detail, it matches that $262k number.

Right now there is a difference of ~$72,020 between the A/R KPI and the A/R Summary/Detail reports. As I said, refreshing things doesn't matter.

How/why are these numbers different? I tried to find some combination/permutation of the detail report that adds up to the $72,020, but I could not.

reddit.com
u/drinianrose — 2 days ago