ISO 9001 clauses implemented (%)

count(status='implemented') / count(applicable clauses) * 100

with applicable as (
        select c.id, coalesce(s.status::text, 'not_implemented') as status
        from qms_clauses c
        left join qms_clause_status s on s.clause_id = c.id
      )
      select case
        when count(*) filter (where status <> 'not_applicable') = 0 then null
        else round(100.0 * count(*) filter (where status = 'implemented')
                 / count(*) filter (where status <> 'not_applicable'), 2)
      end as value
      from applicable

• rangePercent must be in [0, 100]error