Formula
m6 = "Unknown" if m6 == "No" m7 = "Unknown" if m7 == "No" m8 = "Unknown" if m8 == "No" m9 = "Unknown" if m9 == "No" researched = [m1, m2, m3, m4, m5, m6, m7, m8, m9].filter (val) -> val != "NR" numKnown(researched) / researched.length * 100
Water Recycled (%) (G4-EN10-b)
Research lock_open
Global Reporting Initiative
Netherlands
m3
Unknown
%
2018