Oracle Communities

Oracle Analytics and AI

Child Item

How addressable spend is calculated in Procurement Spend analysis?

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.

Find more posts tagged with

Oracle Fusion Analytics

ERP Analytics Content

Fusion ERP Analytics

Accepted answers

All comments

Sumanth V -Oracle

@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

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 ?

Mallikarjuna Kuppauru-Oracle

Hi @Zehra M

Looping Product team for further help -

@Ramamurthy Shankarachetty-Oracle

Regards,

Arjun

Namish Sharma

Hi @Sumanth V -Oracle,

Can you provide an update on the query for the spend to be calculated using purchase order data?

Abdur Rehman

@Zehra M, Did you find a solution to your query?

Zehra M

@Abdur Rehman Not yet.