Categories
- All Categories
- 75 Oracle Analytics News
- 7 Oracle Analytics Videos
- 14K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 40 Oracle Analytics Trainings
- 59 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 3 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
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.
Answers
-
@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.
0 -
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 ?
0 -
0
-
Can you provide an update on the query for the spend to be calculated using purchase order data?
0
