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

Problem with aggregation

Received Response
1
Views
2
Comments
Smakosh
Smakosh Rank 2 - Community Beginner
edited Aug 13, 2024 5:58PM in Oracle Analytics Cloud and Server

Hello,

Question here.  I have combinated analysis like this.  I have formula in yellow  '(Sprz netto * 100/Sprzedaż netto dyn YA)-100'. As you see everything it's good.

pastedImage_0.png

But not in result:

pastedImage_3.png

I tried to do it with different aggregation in result: sum and other on cryteria. I don't have any idea, every column in this report works fine (default aggregation) without this.

Cryteria

pastedImage_4.png

Answers

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    UNION and aggregate calculations are always a problem because you can't really setup a proper aggregation formula... Is the column  NULL in the first part of the UNION and filled with the formula in the second?

    Have you tried switching the two request (putting the second as first)?

    Are you forced to use the UNION is there any way that you can avoid that?

  • Smakosh
    Smakosh Rank 2 - Community Beginner

    No, null is in the second part of the UNION. Yes I tried to switch two request (and the same situation) and I must use UNION because in the second request i must do quantinty for different period then in the first query.

    So, I do sum in another analysis and join everyting on Information desk. That left me.