ZOHO Invoice

Percentage of Paid Invoices

SQL query for ZOHO Invoice

Get the percentage of paid invoices compared to the total number of invoices.

SELECT (COUNT(CASE WHEN invoices.status = paid THEN 1 END) / COUNT(invoices.invoice_id)) * 100 AS Percentage_Paid FROM invoices

ZOHO Invoice data model

ZOHO Invoice
Table Items

ZOHO Invoice
Table Pricebooks

ZOHO Invoice
Table Contacts

ZOHO Invoice
Table Recurringinvoices

ZOHO Invoice
Table Estimates

ZOHO Invoice
Table Customerpayments

ZOHO Invoice
Table Creditnotes

ZOHO Invoice
Table Expenses

ZOHO Invoice
Table Recurringexpenses

ZOHO Invoice
Table Projects

ZOHO Invoice
Table Users

ZOHO Invoice
Table Expensecategories

ZOHO Invoice
Table Taxes

ZOHO Invoice
Table Currencies

ZOHO Invoice
Table Invoices

ZOHO Invoice
Table Invoice Lines

Use SQL on all your SaaS data

Magical SQL for ZOHO Invoice with Peliqan.io

Explore data in a rich spreadsheet UI. Use Magical SQL to combine and transform data. SQL queries become new tables that can be shared with business users and used in any BI tool.

Let AI do the work for you

Peliqan’s AI assistant helps you to write SQL queries to get to insights fast. Ask your question in plain English and immediately see the result in Peliqan’s rich spreadsheet viewer.

Peliqan Ask AI willl write your SQL queries from plain English