Skip to content
RED SAGSkills
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;
Choose one answer

Discussion 0

Join free to post in the discussion.

Related questions