Oracle Analytics Cloud and Server

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

Issue with a division

Received Response
1
Views
1
Comments
Areefa-Oracle
Areefa-Oracle Rank 1 - Community Starter

I have created a report with 2 measures named (a) and (b). Based on the following 2 columns I have created a new column which is a division of the previous 2 columns (b/a).

The problem I am having is that when I exclude one of my attributes then results are getting wrong.

What is the reason if i exclude one of the column getting results wrong.

My total Columns are Six. And if i exclude one attribute giving wrong results.

Please help on this .

Answers

  • Hi,

    Can you be a bit more explicit? What do you mean by "wrong" ?

    Are A and B correct and A/B isn't the result of the division anymore?

    You will have to provide more details to expect some real answers, like also the details of what system you are using (tool, version etc.)