Hi all,
i have a requirement to show percentage of calls in quarter that is lower or higher than district average. iam using the below calculation but its not working, please suggest is there anything wrong im doing below.
num(fabs(((Sum({<MetricId={'3'},QuarterEndDate={'$(=vMaxQuarter)'}>}CALLS_CURRENT_SELL_PERIOD)/
Count(distinct{<MetricId={'3'},QuarterEndDate={'$(=vMaxQuarter)'}>}[%DATE]))
-
(Sum(TOTAL<DISTRICT>{<MetricId={'3'},QuarterEndDate={'$(=vMaxQuarter)'},DISTRICT=p(DISTRICT),TERRITORY_NUMBER=>}CALLS_CURRENT_SELL_PERIOD)/
Count(distinct TOTAL<DISTRICT>{<MetricId={'3'},QuarterEndDate={'$(=vMaxQuarter)'},DISTRICT=p(DISTRICT),TERRITORY_NUMBER=>}[%DATE])))
/
(Sum(TOTAL<DISTRICT>{<MetricId={'3'},QuarterEndDate={'$(=vMaxQuarter)'},DISTRICT=p(DISTRICT),TERRITORY_NUMBER=>}CALLS_CURRENT_SELL_PERIOD)/
Count(distinct TOTAL<DISTRICT>{<MetricId={'3'},QuarterEndDate={'$(=vMaxQuarter)'},DISTRICT=p(DISTRICT),TERRITORY_NUMBER=>}[%DATE]))),'#,##0%')
from the above result if that is greater then 0 im saying Higher else lower than district average, kindly suggest if anything is wrong from the above.
