Hi Team. I have this calculation that is working but not as expected. When I select ANZ and Korea, it gives the correct % but if there's no selection (not ANZ or Korea), it's not showing 38% but only 9%. Seems the Else statement is not being called. Any suggestions?

CASE AP_Dashboard_xlsx.Market
WHEN 'ANZ' THEN (total( AP_Dashboard_xlsx.Headcount for AP_Dashboard_xlsx.Market = 'ANZ') / (ANZ_Forecast_HC )) * 100
WHEN 'KOREA' THEN (total( AP_Dashboard_xlsx.Headcount for AP_Dashboard_xlsx.Market = 'KOREA') / (Korea_Forecast_HC )) * 100
ELSE (total(AP_Dashboard_xlsx.Headcount / 7305)) * 100
END



------------------------------
Camilo Carlo Mendiola
Data Analyst
IBM
------------------------------

#CognosAnalyticswithWatson