Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Incorrect calculation in Union Request

Shantanu RBSep 3 2015 — edited Sep 3 2015

HI,

I want to have a report as below:

Excel report.PNG

To achieve this I have created a Combined request.

The report is based on Week To Date values. I have used the TODATE function to calculate the WTD values

I get the correct results for the first row (Estimated Net Sales) but for the 2nd row (GP Margin %) the percentage value is incorrect.

part1.PNG

The column formula is as below:

FILTER(TODATE("Sales Transactions"."Total Sale Profit", "Business Calendar"."Date Retail Fiscal Calendar"."Fiscal Week") USING ("Sales Transaction Type"."Sales Transaction Type Code" = 'SALE')) * 100 /

FILTER(TODATE("Sales Transactions"."Total Sale Net Amount","Business Calendar"."Date Retail Fiscal Calendar"."Fiscal Week") USING ("Sales Transaction Type"."Sales Transaction Type Code" = 'SALE'))

If I add this column formula to a New Analysis I get the value of 41% but here I get 1188 which is incorrect.

The Aggregation rule on the Pivot is selected as SUM for all the 3 columns.

Am I missing something here?

Thanks & regards,

Shantanu
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 1 2015
Added on Sep 3 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
1 comment
452 views