Oracle Analytics and AI

Steelbird

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.

asim cholas

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

Also in the results change the aggreation rule