Troubleshooting Calculated Metrics in Accolade

Since writing calculated metrics can be tricky, you can access a diagnostics page in the application that provides assistance with identifying and troubleshooting issues that arise in the creation of calculated metric expressions. This page will report errors found in calculated metrics, and can be used to troubleshoot calculated metrics that are not calculating, or are resulting in unexpected values.

To troubleshoot calculated metric errors:

From the System menu, click Diagnostics > Calculation Formulas.
Navigate to the appropriate section:

Section	Description
Metric Function Dependencies	Confirms that metrics that reference other metrics via the CELLVALUE() function, {METRIC:<SystemName>} token, the ROWVALUE() function, or the GETMATRIXCOLUMN() function with a filter have a row in the Metric Dependency table.
Matrix Function Dependencies	Confirms that metrics that reference matrices via the GETMATRIXCOLUMN() function have a row in the Matrix Function Dependency table, and that the SUMMATRIXCOLUMN(), MATRIXCELLVALUE(), and MATRIXROWCOUNT() functions are no longer used.
Metadata Field Code Dependencies	Confirm that metric's that reference metadata field codes via the {MD:<MetadataFieldCode>} token have at least one row in the Metadata dependency table, and that the MetadataFieldCode referenced is valid.
Called Stored Procedure (CSP) Dependencies	Confirm that metric's that reference call stored procedures (CSP) via the CALLSTOREDPROCEDURE() function have the HasStoredProcedure flag set to true and that the CallStoredProcedure referenced is valid.
Linked Project Value (LPV) Dependencies	Confirm that metrics whose formula uses the LINKEDPROJECTVALUES() function have at least one row in the Link Dependency table.
Metadata Code Functions (MCF) Dependencies	Confirm that metrics whose formula uses a Metadata Code Function and have at least one row in the Function Dependency table.
Current Value Function Dependencies	Confirm that metrics whose formula uses the CURRENTVALUE() function only reference the metric that owns the formula.
Current Matrix Value Function Dependencies	Confirm that metrics whose formula uses the CURRENTMATRIXVALUE() function only reference the metric that owns the formula.
Reference Table Function Dependencies	Confirm that metrics whose formula uses the REFERENCETABLE() function and have at least one row in the Reference Table Dependency table.
Resource Demand Function Dependencies	Confirm that metrics whose formula uses the RESOURCEDEMANDS(), RESOURCEDEMANDSFORPOOL(), or RESOURCEDEMANDSFORUOM() functions are flagged as HasResourceDemandFunctions true.
Team Member Function Dependencies	Confirm that metrics whose formula uses the TEAMMEMBER() function and have at least one row in the Team Member Dependency table.
Currency Function Dependencies	Confirm that metrics whose formula uses the CONVERTTOCORPORATECURRENCY() function and are flagged as HasCurrencyFunctions true.
Security List Function Dependencies	Confirm that metrics whose formula uses the SECURITYLIST() function and have at least one row in the Security List Dependency table.
Metric Trigger Analysis	Confirm that only calculated metrics have associated triggers and get counts on the different trigger types.

Click Execute to test all corresponding calculated metrics.

If the test returns calculation errors, the number of affected metrics is reported in red within the corresponding table. Click to expand and review the related details including the formula issue, the possible fix options, and the list of affected metrics. Clicking the name of an affected metric opens the metrics configuration page, where you can edit the calculation expression.

Important! The details section includes a list of commonly recommended steps to resolve calculated metrics issues. Contact Sopheon Customer Support if you need additional assistance.

Learn More: