How addressable spend is calculated in Procurement Spend analysis?

Zehra M · May 8, 2024 9:32AM

Hello,

Need to understand how Fusion analytics is calculating the Addressable Spend for Procurement Spend prebuild analysis.

As per matric calculation it shows the computing logic "Filter("Invoice Amount") Using Is Spend Flag = 'YES' and Is Addressable Flag = 'YES'"

Where "Is Addressable Flag" is marked?

I want to calculate addressable spend based on Purchase Order Ordered Amount using the "Procurement - Purchase Order" subject area instead of "Procurement Spend" which calculates based on Invoice Amount.

Kindly advise.

Sumanth V -Oracle · May 8, 2024 10:24AM

@Zehra M - Please find the Addressable Spend definition as below:

This metric is calculated as Sum of 'Spend' where Invoice Distribution Types are Accrual, Item, Exchange Rate Variance, Invoice Price Variance, Retainage and Retro Active Price Accrual.

Please review the same and let us know if it helps in achieving your requirements.

Zehra M · May 8, 2024 10:28AM

Thanks @Sumanth V -Oracle for the update.

Can you please advise how to calculate addressable spend based on Purchase Order Ordered Amount using the "Procurement - Purchase Order" subject area instead of "Procurement Spend" which calculates based on Invoice Amount ?