Oracle Communities

Oracle Analytics and AI

Child Item

Totals Aggregation in Calculation Formula | OAC

Vismay Barot

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

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

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

Please advise, thank you :)

Find more posts tagged with

OAC

Total

aggregation

Accepted answers

Vismay Barot

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:

But if we divide Sales by this:

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 :)

All comments

Chere-Oracle

Vismay,

Try this formula: SUM( Sales BY Sales Representative Identifier)

Vismay Barot

Thank You @Chere-Oracle, I tried and this Formula didn't worked as well.

However, different approach was pursued so this Case can be closed.

Thank You for your input ☺

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/71662#Comment_71662

Hi @Vismay Barot,

Can you please share the solution here, it'll be helpful for the fellow community members in the future.

Thank you.

RVohra

Please share your approach we also need it.

Vismay Barot

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:

But if we divide Sales by this:

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 :)

RVohra

Thanks @Vismay Barot . please close the post as Accepted answer.