Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Applying a filter to a COUNT

Accepted answer
596
Views
17
Comments
2»

Answers

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    @Mostafa Morsy-Oracle in order for that screenshot to be valuable to the OP please also include the formula you used for your calculation of "Amount" under "My Calculations".

    The confusion in this thread exists because of insufficient details being shared and a solution can only be made clear to any forum user browsing this thread by being precise and clear.

    If people have to patch together bits and pieces of information across 10 posts, then the thread does not provide much value to the community at large.

  • Mostafa Morsy-Oracle
    Mostafa Morsy-Oracle Rank 6 - Analytics Lead

    @Christian Berg will provide the formula and all steps once @Mirithu confirm that screen shot meet his expectation because it will be confusing for other users who looking for same to check the formula blindly without confirming the solution from the requester

  • [Deleted User]
    [Deleted User] Rank 7 - Analytics Coach

    Hello @Mirithu can you please update this thread? Several people have tried to help you and Mostafa has a solution for you.

    If you abandon your thread it won't resolve your issue nor will it help other forum users to benefit.

    Thanks!

  • Mirithu
    Mirithu Rank 3 - Community Apprentice

    My apologies for my explanation not being clear enough.

    Thank you @GayathriAnand-Oracle.

    Thank you @Mostafa Morsy-Oracle , your calculation works. Its what I was looking for.

  • Mostafa Morsy-Oracle
    Mostafa Morsy-Oracle Rank 6 - Analytics Lead

    @Mirithu please check above☝️

  • Mirithu
    Mirithu Rank 3 - Community Apprentice

    Yes @Mostafa Morsy-Oracle, it works perfectly in my case. Thank you.