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

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