Applying a filter to a COUNT

[Deleted User] · May 31, 2024 9:18AM

@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 · May 31, 2024 6:42PM

@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] · Jun 4, 2024 7:45AM

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 · Jun 4, 2024 11:01AM

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 · Jun 5, 2024 12:14AM

@Mirithu please check above☝️

Mirithu · Jun 5, 2024 1:17PM

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

Oracle Analytics Forum

Categories

Applying a filter to a COUNT

Answers