how to do string compare?
I am trying to filter records what are having status only as 'paid' or 'overdue'.
Can someone clarify how to have this? Thank you.
either Having status as Overdue or Paid
or having status not as draft
line written in zoho analytics SQL?
SELECT
sum("Total"),
"idnumber"
FROM "LBI"
GROUP BY "idnumber"
Having status as Overdue or Paid or having status not as draft