Oracle Fusion Data Intelligence

Home› Oracle Analytics› Forums› Oracle Fusion Data Intelligence› Oracle Fusion Data Intelligence

Categories

Welcome to the Oracle Analytics Online Forum!

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!

Filter the Same Part Number in Current Year and Last Year

Received Response
15
Views
2
Comments
JobDeLuna
JobDeLuna ✭✭✭✭
edited August 13 in Oracle Fusion Data Intelligence

Hi,

How can I create a calculation that will filter the Part Numbers common for Fiscal Year 2023 and 2024?

when the same it should be Yes else No.

My plan is to add a filter that will show only the comparable spend of common purchase part number:

image.png

Here are the fields to be used:
"Procurement - Direct Material Spend"."Time"."Fiscal Year Number"

"Procurement - Direct Material Spend"."Voucher Invoice Details"."Part Number"

Tagged:

Answers