Formula
m3 = "Unknown" if [m3].flat()[0] == "None" m4 = "Unknown" if [m4].flat()[0] == "In Development" m5 = "Unknown" if [m5].flat()[0] == "No - neither" noIsUnknown = [m4, m5, m6, m7, m8, m9, m10, m11, m12, m13, m14, m15, m16, m17, m18, m19, m20, m21, m22, m23] numNo = noIsUnknown.filter((a) -> [a].flat()[0] == "No" ).length researched = [m1, m2, m3].concat(noIsUnknown).flat().filter (val) -> val != "NR" (numKnown(researched) - numNo) / researched.length * 100
Walk Free
m4
Modern Slavery Statement
Research lock_open
Business & Human Rights Resource Centre
m5