Adding 2 columns with '+' treats numbers as strings (not fixed with cast)
Why does the '+' sign converts numbers into strings? How to fix it?
Note: cast( as int) + cast( as int) does not work ("Parsing of Query failed, please check the syntax").
The following SQL should sum up two numbers, like: 0 + 10000
Expected result: 10000
Actual result: "010000"
- case when Type='Renewal' and sum("No. Licenses") over(partition by "Account Name" ORDER BY "Contract Start Date") > 0 then "No. Licenses"
- else sum(case when Type!='Renewal' then "No. Licenses" else 0 end)
- over(partition by "Account Name" ORDER BY "Contract Start Date" rows between unbounded precedent and current row )
- end
- +
- case when Type!='Renewal' and "Contract Start Date" != first_value("Contract Start Date") over(partition bypartition by "Account Name")
- and first_value("No. Licenses") over(partition by "Account Name" ) = 0
- then first_value("No. Licenses") over(partition by "Account Name" ORDER BY case when "No. Licenses" = 0 then 2 else 1 end, "Contract Start Date" )
- else 0
- end as cummulative_licenses
New to Zoho LandingPage?
Zoho LandingPage Resources
New to Zoho Survey?
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho CRM Plus?
Deliver unforgettable customer experiences
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Zoho Marketing Plus?
Everything you need to run your marketing
New to Bigin?
Topic Participants
Isis
Janani Thakshayani
Sticky Posts
Zoho Analytics: 2021 Look Back
As we start a new year in 2022, here's some of our top moments from 2021. Zoho Analytics in 2021[Customer Talk] PREMO Group's Analyst Interview at Zoho Day 2022
Premo Group, a 50 year old Spanish Manufacturing Company, has been our long-standing customer with #ZohoAnalytics. They've been using our platform for their end-to-end, unified business analytics solution. Hear more from Claudio Cabeza, Director at PREMOAnnouncing Zoho Analytics 5.0 -- A Modern Self-service BI & Analytics Platform
We are extremely delighted to unveil Zoho Analytics 5.0 - A Modern Self-service BI and Analytics platform to the public. Experience analytics like never before with the following new capabilities and enhancements: Comprehensive AI-Powered Data PreparationZoho Analytics | Quarterly Newsletter | Q2 2022
Hello Everyone! I hope all of you are safe and well! Zoho Analytics - Q2 Quarterly Newsletter is out now! Check out the newsletter (attachment) to know all about our new features, recognitions, webinars, blogs, and many more exciting things. Do let usUpdate on the recent Apache Log4j2 vulnerabilities - Impact on Zoho Analytics On Premise Deployments
Dear Users, Three high severity vulnerabilities (CVE- 2021-44228, CVE-2021-45105 and CVE-2021-45046), impacting multiple versions of Apache Log4j utility, was disclosed publicly on December 9, 2021. We have found no evidence of any successful exploitation
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho DataPrep Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator Resources
Zoho WorkDrive Resources
Zoho Campaigns Resources
Zoho CRM Resources
Design. Discuss. Deliver.
Zoho Show Resources
Get Started. Write Away!
Writer is a powerful online word processor, designed for collaborative work.
Zoho CRM コンテンツ
-
オンラインヘルプ
-
Webセミナー
-
機能活用動画
-
よくある質問
-
Ebook
-
-
Zoho Campaigns
- Zoho サービスのWebセミナー