medium10 pts · first answer countsratio-analysissqlworking-capital
DSO query returns zero
In PostgreSQL, receivables and revenue are both INTEGER columns. This query returns 0 for nearly every customer. Why?
SELECT customer_id,
receivables / revenue * 365 AS dso
FROM ar_summary;Discussion 0
Join free to post in the discussion.
Related questions
- Calculating the current ratioFinancial Analyst
- Calculating the quick ratioFinancial Analyst
- Net working capital amountFinancial Analyst
- Return on equityFinancial Analyst
- Inventory turnoverFinancial Analyst
- Classifying trade payablesFinancial Analyst
- Receivables went upFinancial Analyst
- DSO from receivables and revenueFinancial Analyst