Skip to main content
DD-CFP-002 Mizan Group: How Good Is the Treasury's Forecast? — Cash Flow Planning Get the data →
DD-CFP-002-Q020 Medium Time series

Logistics' near-term bias

The actual of a forecast line in a week = the sum of Amount of that company's bank rows dated from WeekStart to WeekStart + 6 whose Category maps to that ForecastLine in DimCategory. Bias % = 100 x (total forecast - total actual) / total actual. For Mizan Logistics' "Customer receipts", over all versions dated in 2025, what is the bias % of WeekNumber 1? 2 decimals.
Expected
One percentage, 2 decimals · KPI card
Tables
FactForecast, FactBankTransactions, DimCategory · columns
  • FactForecast
  • FactBankTransactions
  • DimCategory
  • VersionID
  • VersionDate
  • WeekNumber
  • WeekStart
  • ForecastLine
  • Amount
  • TransactionDate
  • EntityCode
  • Category

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us