Calculation Issues

Major Issues Effecting Health Report

• [ ] Calc Referenced Metric value_undeposited_funds in Calculation for metric `healthover_undeposited
• [ ] Calc Referenced Metric count_undeposited_funds_notdeposited in Calculation for metric `health_over @count_undeposited_funds_notdeposited/@count_payment

Missing Calculation

==ISSUE: These calculations are missing:==

SELECT * FROM AutyScoreCardTemplate.MetricTemplate m WHERE m.Id IN ('value_undeposited_funds','count_undeposited_funds_notdeposited','filter_days_in_period_entered', 'value_long_term_liabilities','value_gross_profit','value_current_liabilities')

• [ ] Error - TAB MetricCalculation for Metric health_over_undeposited_funds_balance has the following issue: Calc Referenced Metric value_undeposited_funds in Calculation for metric health_over_undeposited_funds_balance for calculation @value_undeposited_funds/@value_bank please update the calculation to use a Metric Key that exists..
• [ ] Error - TAB MetricCalculation for Metric health_over_undeposited_funds_transaction_count has the following issue: Calc Referenced Metric count_undeposited_funds_notdeposited in Calculation for metric health_over_undeposited_funds_transaction_count for calculation @count_undeposited_funds_notdeposited/@count_payment please update the calculation to use a Metric Key that exists..
• [ ] Error - TAB MetricCalculation for Metric value_accounts_receivable_turnover has the following issue: Calc Referenced Metric filter_days_in_period_entered in Calculation for metric value_accounts_receivable_turnover for calculation (@value_accounts_receivable/@value_income)/@filter_days_in_period_entered please update the calculation to use a Metric Key that exists..
• [ ] Error - TAB MetricCalculation for Metric value_cash_flow_to_debt has the following issue: Calc Referenced Metric value_long_term_liabilities in Calculation for metric value_cash_flow_to_debt for calculation ((@value_net_income+@value_deprec_amort)/@value_long_term_liabilities) please update the calculation to use a Metric Key that exists..
• [ ] Error - TAB MetricCalculation for Metric value_gross_margin has the following issue: Calc Referenced Metric value_gross_profit in Calculation for metric value_gross_margin for calculation (@value_gross_profit / @value_income) please update the calculation to use a Metric Key that exists..
• [ ] Error - TAB MetricCalculation for Metric value_quick_ratio has the following issue: Calc Referenced Metric value_current_liabilities in Calculation for metric value_quick_ratio for calculation ((@value_bank+@value_accounts_receivable)/@value_current_liabilities) please update the calculation to use a Metric Key that exists.

Cannot Include a calculation in a custom Drill down:

• [ ] Error - Parse error details Error - TAB MetricDrillDown for Metric Accounts_Receivable_Metrics_Summary has the following issue: Key Value percentage_invoice_open is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @valueInvoice_open/@value_Accounts_Receivable .
• [ ] Error - TAB MetricDrillDown for Metric Accounts_Receivable_Metrics_Summary has the following issue: Key Value percentage_invoice_past_due is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @value_Invoice_past_due/@value_Accounts_Receivable .

• [ ] Error - TAB MetricDrillDown for Metric Accounts_Receivable_Metrics_Summary has the following issue: Key Value health_over_unapplied_payments is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @health_over_unapplied_payments/@count_Payment .

• [ ] Error - Parse error details Error - TAB MetricDrillDown for Metric Bank_Metrics_Summary has the following issue: Key Value health_over_trans_not_reconciled_bank is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @count_recon_bank_unreconciled/@count_bank .
  Error - TAB MetricDrillDown for Metric Bank_Metrics_Summary has the following issue: Key Value change_Bank|AccountName is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @CALC_PreviousPeriod-@CALC_CurrentPeriod .

• [ ] Error - Parse error details Error - TAB MetricDrillDown for Metric Credit_Card_Metrics_Summary has the following issue: Key Value health_over_trans_not_reconciled_credit_card is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @count_recon_credit_card_unreconciled/@count_credit_card .

• [ ] Error - TAB MetricDrillDolwn for Metric Credit_Card_Metrics_Summary has the following issue: Key Value change_Credit_Card|AccountName is a Calculation and calculations are not supported as a drilldownable metric type. Write custom sql if this is the case. Here is the calculation: @CALC_PreviousPeriod-@CALC_CurrentPeriod .

Missing Parms for SQL Testing

• [ ] Warn - The value ‘AccountNamewas not provided in the parmsStagingDbName: CL_Argi_Prodfor interpolation stringSELECT
  SouId_Account AS SouId_Account
  , AccountName
  , FORMAT(MAX(Balance), ‘C0’) as [Amount of Credit Card AsOf by Account]
  , FORMAT(DATEDIFF(Day,MAX(Date), GETDATE()), ‘M/dd/yy’) as [Date of last Reconciled for Credit Card {AccountName}]
  , FORMAT(COUNT(), ‘0’) as [Number of Credit Card transactions by Account]
  , FORMAT(COUNT(), ‘0’) as [Number of Reconciled for Credit Card {AccountName}]
  FROM {StagingDbName}.Mart.GeneralLedgerDetailReport
  WHERE ProjectId = @ProjectId
  AND Date BETWEEN @BeginDate AND @EndDate
  GROUP BY AccountName, SouId_Account
  `. Please ensure that this value is provided in the request.
• [ ] Warn - The value ‘AccountNamewas not provided in the parmsStagingDbName: CL_Argi_Prodfor interpolation stringSELECT
  SouId_Account AS SouId_Account
  , AccountName
  , FORMAT(MAX(Balance), ‘C0’) as [Amount of Credit Card AsOf by Account]
  , FORMAT(DATEDIFF(Day,MAX(Date), GETDATE()), ‘M/dd/yy’) as [Date of last Reconciled for Credit Card ]
  , FORMAT(COUNT(), ‘0’) as [Number of Credit Card transactions by Account]
  , FORMAT(COUNT(), ‘0’) as [Number of Reconciled for Credit Card ]
  FROM {StagingDbName}.Mart.GeneralLedgerDetailReport
  WHERE ProjectId = @ProjectId
  AND Date BETWEEN @BeginDate AND @EndDate
  GROUP BY AccountName, SouId_Account
  `. Please ensure that this value is provided in the request.