Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Union Report - Grand total % column not Calculating Properly

Received Response
1
Views
1
Comments
Steelbird
Steelbird Rank 4 - Community Specialist
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

Hi @Team ,@Jerry Casey

I have union data set where the Grandtotal for % is not calculating Properly.

First Data Set: Region1, MTDAmt,PYAmt % Column (Formula 100 *(MTDAmt/PYAmt)

Individually the above data set calculates properly for % column.

Second Data Set: Region2, MTDAmt, Null Column

When we are doing union on both data sets then Whatever the First value of % column available in first Data Set it is populating in Grandtotal for % column.

Thank you,

Steel.

Tagged:

Answers

  • asim cholas
    asim cholas Rank 6 - Analytics & AI Lead

    instead of NULL keep 0 and set aggregation field as sum/average.

    Also in the results change the aggreation rule