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%