3 Replies Latest reply on Sep 17, 2018 12:48 AM by pullarao miriyala

    i am not able to find average of average

    pullarao miriyala

      Hi All,

       

      I am trying to calculate scorecards which contain columns i have already averaged it on top of the average i want to find out overall average.

       

      example:  ((avg[col1]+avg[col2]+avg[col3])/3 +  (avg[col4]+avg[col5]+avg[col6]+avg[col7]+avg[col8])/5)/2

       

      i am trying to calculate like above what i have given but it is showing null i am not able to find solution can please tell me how to calculate.