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+Image](https://dq06ugkuram52.cloudfront.net/files/1831839/40123173-icon.png)
Walk Free
Australia
m4
Modern Slavery Statement
Research lock_open
![Business & Human Rights Resource Centre+Image](https://dq06ugkuram52.cloudfront.net/files/1827666/26524298-icon.png)
Business & Human Rights Resource Centre
United Kingdom
m5