Hi All,
I have the next mat view:
CREATE MATERIALIZED VIEW mat_vw_phase_count REFRESH FAST ON COMMIT WITH ROWID AS
select req_id, unit_type_id, perf_l, fy
,COUNT(*)
,COUNT(CASE WHEN phase_name = 'M' THEN 1 ELSE 0 END) AS count_m_count
,COUNT(CASE WHEN phase_name = 'B' OR phase_name = 'Z' THEN 1 ELSE 0 END) AS count_b_count
,COUNT(CASE WHEN phase_name = 'A' THEN 1 ELSE 0 END) AS count_a_count
,COUNT(CASE WHEN phase_name = 'D' THEN 1 ELSE 0 END) AS count_d_count
,COUNT(CASE WHEN phase_name = 'S' THEN 1 ELSE 0 END) AS count_s_count
,SUM(request) as request
,SUM(CASE WHEN phase_name = 'M' THEN 1 ELSE 0 END) AS m_count
,SUM(CASE WHEN phase_name = 'B' OR phase_name = 'Z' THEN 1 ELSE 0 END) AS b_count
,SUM(CASE WHEN phase_name = 'A' THEN 1 ELSE 0 END) AS a_count
,SUM(CASE WHEN phase_name = 'D' THEN 1 ELSE 0 END) AS d_count
,SUM(CASE WHEN phase_name = 'S' THEN 1 ELSE 0 END) AS s_count
,COUNT(phase_name) as total_count
from mat_vw_ofrp_phases
group by req_id, unit_type_id, perf_l, fy;
The code works fine until I try to divide the request as: ,SUM(request)/12 as request
I got an error, why the division by 12 is an issue?
Is there a work around this?
Thanks!
