Variable |
Metric |
Value |
Year |
m1 |
|
No value |
latest |
m2 |
|
No value |
latest |
m3 |
|
No value |
latest |
m4 |
|
No value |
latest |
m5 |
|
Yes |
latest |
m6 |
|
No value |
latest |
m7 |
|
No value |
latest |
m8 |
|
No value |
latest |
Formula
= m7 = "Yes" if ["Already Achieved", "By 2020", "By 2030", "By 2040", "By 2050", "After 2050"].includes m7
m8 = "Yes" if ["Core Partner", "Participant"].includes m8
if [m1, m2, m3, m4, m5, m6, m7, m8].includes "Yes"
"Yes"
else
"No"