Oracle Fusion AI Data Platform Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Fusion AI Data Platform Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Filter the Same Part Number in Current Year and Last Year

Received Response
21
Views
2
Comments
JobDeLuna
JobDeLuna Rank 5 - Community Champion
edited Aug 13, 2024 7:25PM in Oracle Fusion AI Data Platform Forum

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