Skip to main content

Peliqan

Try for free
Request a demo

Forecasted Revenue vs. Budgeted Revenue

SQL query for D2O

Compare the forecasted revenue and budgeted revenue for each account.

SELECT a.account, f.revenue as forecasted_revenue, b.revenue as budgeted_revenue FROM accountvalues_forecast f INNER JOIN accountvalues_budget b ON f.account = b.account

Try this query now in D2O

D2O data model

Ready to get instant access to all your company data ?​

Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.

  • 14-day free trial
  • No credit card needed