OVER.......PEARTITION BU Query not working

OVER.......PEARTITION BU Query not working

Hello Admin.

I'm Using Partition By query in Zoho Query table below is query

SELECT
"Year",
"Month",
"1st of Month",
"Zone Code",
"Zone Name",
"Zone Short Name",
SUM("Line Total INR") OVER (PARTITION BY "Zone Code") As   'Sales Actual',
             SUM("Line Total INR") OVER (PARTITION BY "1st of Month")  As 'Org Sales Actual'

FROM  "Q Sales Invoice Data"
WHERE "Series Name"  Not IN ('IV06', 'IV08', 'IV22', 'IV23')
AND ISNULL("Zone Short Name",'0')  in ( 'Zone A', 'Zone B', 'Zone C', 'Zone D', 'Zone E', 'Zone F')


But when I'm executing query it's giving me below error
Error Details:

Parsing of Query failed, please check the syntax.

Kindly help me on this.

Thanks & Regards



      • Sticky Posts

      • Connect with Zoho users from your industry, virtually!

        A couple of years ago, we started setting up industry-wise channels for users with similar businesses to chat and discuss Zoho contextually. We started with Real Estate and E-commerce sectors, creating a chatroom and hosting regular meetups on niche areas

      • Feature update: Advanced security settings

        We've previously written about how using security policies could be beneficial for admins. To enable you to better protect your organization, we've come up with a few additional settings for security policies in Zoho One that can be used to regulate your users' web sessions. What are web sessions? A web session refers to the period of time you stay signed in to your Zoho One account. You create a new web session every time you sign in to Zoho One (or any of its included apps), and this session exists