Oracle Fusion Data Intelligence

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

Filter Common Value Across Multiple Years

Received Response
154
Views
18
Comments
2»

Answers

  • Rank 3 - Community Apprentice

    Aggregation will not work within filter, that's the simple rule. Try converting that as well to case statement.

    CASE WHEN count(distinct case when "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2023' or "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" = '2024' THEN "Procurement - Direct Material Spend"."Time"."Fiscal Year Number" END by "Procurement - Direct Material Spend"."Voucher Invoice Details"."Part Number" ) >= 2 THEN "Actual Spend Amount" ELSE 0 END

  • Rank 5 - Community Champion
    edited Jun 3, 2024 7:39AM

    I tried the said calculation however the result is 0 which should not be.

  • Rank 3 - Community Apprentice

    Please share the entire report XML. I can give a try.

  • Rank 3 - Community Apprentice

    This is easy if you do in pivot table, two columns represent date from two different years. The last one is a calculated column.

    Just click on advanced tab and copy everything from XMLAnalysis window in a text file and share here.

  • Rank 5 - Community Champion

    Hi, @Bharat Agrawal have you check on it? Looking forward to positive response. Thank you! I appreciate your help.

  • Rank 3 - Community Apprentice

    Sorry bit busy with day job, will look into it later this week or weekend. would you find sharing your linkedin profile here, so I can pm you my contact details.

  • Rank 5 - Community Champion
    edited Jun 4, 2024 9:10AM

    No problem. Here's my linkedin profile. Thanks Bharat!

    https://www.linkedin.com/in/joven-de-luna-204132a5/

  • Rank 3 - Community Apprentice

    Great, will ping you

Welcome!

It looks like you're new here. Sign in or register to get started.