Hi Everyone!
I am trying to calculate percentages using array formulas. I have a dashboard that will show the allotment of cases for each day. Part of the dashboard is to show the % cases by day. Can someone tell me what I am doing wrong with my formula
For cell b4=(SUM(IF((TypeofCase="Emergency")*(DateofActivity=($A10-1)),1,0)+SUM(IF((TypeofCase="Emergency")*(DateofActivity=$A10),1,0))))/SUM(IF((COUNTA(TypeofCase)),1,0))
For cell c4=(SUM(IF((TypeofCase="Non-Emergency")*(DateofActivity=($A10-1)),1,0)+SUM(IF((TypeofCase="Non-Emergency")*(DateofActivity=$A10),1,0))))/SUM(IF((COUNTA(TypeofCase)),1,0)