2 Replies Latest reply: Oct 27, 2011 7:43 AM by Ben Reed RSS

    Aggregate chart function help

    Ben Reed

          I have the following data set and want to show the percent of what percent of "AVG_HRS" "EFF_HRS" is for the selected period.  In order to do this i need to add all values for AVG_HRS where TAT_INDICATOR is not equal to 'NA' for the selected date range and devide that by the sum value of EFF HRS for the same date range where TAT_INDICATOR is not equal to NA.  I have been unable to acheive this.  Can someone help please?

       

      The numberical formula should be 70.3/62.25 = 113%

       

       

      TAT_INDICATOR        WO_NO    EFF_HRS    AVG_HRS
      HIGH11046717.521.9
      CONTROLLED1119452224.2
      LOW11394322.7524.2
      NA1130356
      NA1145241