Aggregate chart function help

[#1]

    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
HIGH	110467	17.5	21.9
CONTROLLED	111945	22	24.2
LOW	113943	22.75	24.2
NA	113035	6
NA	114524	1

[#2 · Accepted solution]

hi

Just a If statement

=sum ( if(TAT_INDICATOR  <>'NA' ,  AVG_HRS  )  ) /  sum ( if(TAT_INDICATOR  <>'NA' ,  EFF_HRS  )  )

regards

JJ

[#3]

Thanks JJ that worked out perfectly.   I was overcomplicating it.