Procurement Analysis calculated measures and KPIs

This table shows the Procurement Analysis measures that are calculated and defined as saved expressions. The saved expressions use the Invoice Date and Sum aggregation.

Measure Description
Invcd Appr vs Insp Qty Pct Approved quantity in invoice divided by the inspected quantity
Invcd Rejected vs Rcvd Pct Rejected quantity in invoice divided by the received quantity
Lines Qty as Req Pct Number of lines where the received quantity is equal to the requested quantity divided by the number of lines
Lines Qty as Conf Pct Number of lines where the received quantity is equal to the confirmed quantity divided by the number of lines
Lines Qty Rcvd More than Req Pct Number of lines with an overshipped quantity compared to the requested quantity divided by the number of lines
Lines Qty Rcvd More than Conf Pct Number of lines with an overshipped quantity compared to the confirmed quantity divided by the number of lines
Lines Qty Rcvd Less than Req Pct Number of lines where the received quantity is less than the requested quantity divided by the number of lines
Lines Qty Rcvd Less than Conf Pct Number of lines where the received quantity is less than the confirmed quantity divided by the number of lines
Avg Days Diff – Order and Rcvd Goods receiving days between order and received dates divided by the number of lines