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

Totals Aggregation in Calculation Formula | OAC

Accepted answer
78
Views
6
Comments
Vismay Barot
Vismay Barot Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Greetings Community, currently I've to do Totals Aggregation = "Sum" for displaying desired value:

image.png

However, how can I put this in terms of Calculation?
I tried this but doesn't work:

image.png

I want to put this in Calculation because I will use that in further Formulas.

Please advise, thank you :)

Tagged:

Best Answer

  • Vismay Barot
    Vismay Barot Rank 5 - Community Champion
    Answer ✓

    Greetings @Bhaskar Konar & @RVohra , I can certainly share the workaround.

    So earlier the problem was this Formula was used to count Average and it didn't take into consideration of Highlighted Green because technically No Sale was made so no Data for Month:

    image.png

    But if we divide Sales by this:

    image.png

    This will provide accurate Average regardless of Sale is made or not.

    Hope this clarifies.

    Please let me know if there is a better/efficient alternative to this.
    Thank You :)

Answers