We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
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
