M0 function stops working after M9 on formula metrics

+Status
Closed
+*when created
Tuesday, July 02, 2019 03:22 PM UTC
 
 

I tried to create a formula with 28 metrics. I hit an error which (I think) is because the M0 formula stops working after M9. I think the system is adding an extra digit to the metric name and taking only the first number of the two-digit M number.

M1 was Direct greenhouse gas (GHG) emissions (Scope 1) and M2 was Hazardous waste recycled. Here is the error message:

Problems with Nottingham Trent SDG Summer School 2019 Research Group+Nottingham Trent SDG Disclosure Rate+Formula

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)0 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)1 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)3 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)4 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)5 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)6 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)7 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)8 doesn't exist

FORMULA: input metric Global Reporting Initiative+Direct greenhouse gas (GHG) emissions (Scope 1) (G4-EN15-a)9 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)0 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)1 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)2 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)4 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)5 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)6 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)7 doesn't exist

FORMULA: input metric Global Reporting Initiative+Hazardous waste recycled (G4-EN23-a)8 doesn't exist

 

Formula: 

26 - Unknowns[ \view (Unknown) not supported for M0,\

,\view (Unknown) not supported for M2,\view (Unknown) not supported for M3,\view (Unknown) not supported for M4,\view (Unknown) not supported for M5,\view (Unknown) not supported for M6,\view (Unknown) not supported for M7,\view (Unknown) not supported for M9,\view (Unknown) not supported for M10,\view (Unknown) not supported for M11,\view (Unknown) not supported for M13,\view (Unknown) not supported for M14,\view (Unknown) not supported for M15,\view (Unknown) not supported for M16,\view (Unknown) not supported for M17,\view (Unknown) not supported for M18,\view (Unknown) not supported for M19,\view (Unknown) not supported for M20,\view (Unknown) not supported for M21,\view (Unknown) not supported for M22,\view (Unknown) not supported for M24,\view (Unknown) not supported for M25,\view (Unknown) not supported for M26,\view (Unknown) not supported for M27,\view (Unknown) not supported for M28 ]

Link to the metric: https://wikirate.org/Nottingham_Trent_SDG_Summer_School_2019_Research_Group+Nottingham_Trent_SDG_Disclosure_Rate

 

I think I spotted the bug. Deploying fix to staging now.

Ethan McCutchen.....2019-07-02 18:06:36 UTC

I just tried it on staging & it's working - thanks!

Aileen Rob.....2019-07-03 08:58:33 UTC

deployed to live. closing

Ethan McCutchen.....2019-07-04 04:43:27 UTC