Oracle Analytics Cloud and Server

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

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 Lead

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

    Also in the results change the aggreation rule