Cost Per square meter Calculation
I have the following data;
| IssueNo | Consumeddivision | Week | Year | IssueValue | Area | Period |
| 1056492 | CHEP | 13 | 2013 | 5169 | 149615 | 4 |
| 1056492 | CHEP | 13 | 2013 | 7236.6 | 149615 | 4 |
| 1056492 | CHEP | 13 | 2013 | 15507 | 149615 | 4 |
| 1056492 | CHEP | 13 | 2013 | 24122 | 149615 | 4 |
| 1056493 | SIMO | 13 | 2013 | 7236.6 | 178349 | 4 |
| 1056499 | CHEP | 13 | 2013 | 758.12 | 149615 | 4 |
| 1056500 | CHEP | 13 | 2013 | 87.6 | 149615 | 4 |
| 1056501 | KAP | 13 | 2013 | 17.52 | 92480 | 4 |
| 1056502 | SIMO | 13 | 2013 | 26.28 | 178349 | 4 |
| 1055524 | CHEP | 7 | 2013 | 2146.2 | 149615 | 2 |
| 1055525 | TOR | 7 | 2013 | 1620.6 | 199100 | 2 |
| 1055525 | TOR | 7 | 2013 | 3540.1 | 199100 | 2 |
| 1055525 | TOR | 7 | 2013 | 3854.4 | 199100 | 2 |
| 1055525 | TOR | 7 | 2013 | 8584.8 | 199100 | 2 |
| 1055526 | KAP | 7 | 2013 | 1376 | 92480 | 2 |
| 1055526 | KAP | 7 | 2013 | 7008 | 92480 | 2 |
| 1055526 | KAP | 7 | 2013 | 3034.37 | 92480 | 2 |
| 1055526 | KAP | 7 | 2013 | 1620.6 | 92480 | 2 |
| 1055526 | KAP | 7 | 2013 | 578.16 | 92480 | 2 |
| 1055526 | KAP | 7 | 2013 | 735.84 | 92480 | 2 |
| 1055530 | KAP | 7 | 2013 | 5080 | 92480 | 2 |
| 1055530 | KAP | 7 | 2013 | 1314 | 92480 | 2 |
| 1055531 | KAPT | 7 | 2013 | 10160 | 90845 | 2 |
| 1055531 | KAPT | 7 | 2013 | 16640.4 | 90845 | 2 |
| 1055531 | KAPT | 7 | 2013 | 5256 | 90845 | 2 |
| 1055531 | KAPT | 7 | 2013 | 4230.8 | 90845 | 2 |
| 1055531 | KAPT | 7 | 2013 | 15767.25 | 90845 | 2 |
| 1055532 | KAP | 7 | 2013 | 16640.2 | 92480 | 2 |
| 1055532 | KAP | 7 | 2013 | 15767 | 92480 | 2 |
| 1055533 | CHEP | 7 | 2013 | 10158.62 | 149615 | 2 |
| 1055533 | CHEP | 7 | 2013 | 16640.4 | 149615 | 2 |
| 1055533 | CHEP | 7 | 2013 | 5256 | 149615 | 2 |
| 1055533 | CHEP | 7 | 2013 | 15767.23 | 149615 | 2 |
| 1055533 | CHEP | 7 | 2013 | 24528 | 149615 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055548 | KAPT | 7 | 2013 | 300 | 90845 | 2 |
| 1055550 | CHEP | 7 | 2013 | 7560.67 | 149615 | 2 |
| 1055550 | CHEP | 7 | 2013 | 1620.6 | 149615 | 2 |
| 1055550 | CHEP | 7 | 2013 | 3942 | 149615 | 2 |
| 1055550 | CHEP | 7 | 2013 | 2430.9 | 149615 | 2 |
| 1055550 | CHEP | 7 | 2013 | 4300 | 149615 | 2 |
| 1055551 | KAP | 7 | 2013 | 1376 | 92480 | 2 |
I need to achieve the following;
Calculate the cost per square meter which is basically - The sum cost of Issuevalue/Distinct SUM OF Area, The Area varies for the different consumeddivision and based on the selections on the consumeddivision in the filter, We should have the sum of the Area of the selections e.g
If we Select Chep and Kap in consumeddivision filters we should have the sum of issuevalue for the two locations/Sum area of (Chep and Kap)
Thanks and looking forward to your assistance
Regards
Access your files securely from anywhere
New to Zoho Recruit?
Zoho Developer Community
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
gsang
1_Pavithra V
Sticky Posts
What's New in Zoho Analytics - November 2025
We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What'sWhat's New in Zoho Analytics - October 2025
Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! ExtremeWhat’s New in Zoho Analytics – September 2025
Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expandedAnnouncing Agentic AI - Ask Zia!
We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.Invitation-Based User Access in Zoho Analytics
Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security
New to Zoho TeamInbox?
Zoho TeamInbox Resources
Zoho CRM Plus Resources
Zoho Books Resources
Zoho Subscriptions Resources
Zoho Projects Resources
Zoho Sprints Resources
Qntrl Resources
Zoho Creator 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セミナー
その他のサービス コンテンツ
Nederlandse Hulpbronnen
ご検討中の方
Recent Topics
Cliq Networks users can see all other network users contact information
Is there a way to hide user contact information from each user in networks? I would only like the users to see the admin's contact information, not other users. Network users information shared by defaultFix the speed
It takes ages to load on every step even though my dataset is quite small.Zoho Sheet - Printing - Page Breaks and Printing Customization
I think the title is descriptive enough in that I cannot find help documentation on a simple task of adding in page brakes for separating pages on print. ThanksMissing the "Find & Merge Duplicates" choice
Hi, I am missing the "Find & Merge Duplicates" choice. I looked under the "More Actions" menu in Contacts, Accounts, Vendors, and Leads and it is not there. I have full permissions. Please assist me on finding this feature. Thanks!OAuth integration issues
I'm experiencing persistent OAuth errors when trying to connect Make with Zoho API. I've tried multiple approaches but keep encountering the following issues: First error: 'Invalid Redirect Uri - Redirect URI passed does not match with the one configured'Bigin, more powerful than ever on iOS 26, iPadOS 26, macOS Tahoe, and watchOS 26.
Hot on the heels of Apple’s latest OS updates, we’ve rolled out several enhancements and features designed to help you get the most from your Apple devices. Enjoy a refined user experience with smoother navigation and a more content-focused Liquid GlassZoho CRM for Everyone's NextGen UI Gets an Upgrade
Hello Everyone We've made improvements to Zoho CRM for Everyone's Nextgen UI. These changes are the result of valuable feedback from you where we’ve focused on improving usability, providing wider screen space, and making navigation smoother so everythingAbility to Edit Ticket Subject when Splitting a Ticket
Often someone will make an additional or new request within an existing ticket that requires we split the ticket. The annoying part is that the new ticket maintains the subject of the original ticket after the split so when the new ticket email notificationMarketing Tip #16: Ideal sizes and formats for adding images to your online store
Images can make (or break) your storefront experience. When your banners and product photos follow the right sizes and aspect ratios, your store looks cleaner, loads faster, and feels more trustworthy—especially on mobile. Here are recommended image sizesImprove WhatsApp Module in Zoho CRM
The current WhatsApp module UI in Zoho CRM feels cluttered and complex, especially when handling high volumes of conversations. It would be great to enhance the WhatsApp module UI/UX by adopting a clean and simplified interface similar to Bigin CRM’sBlueprint transitions on locked records
We use the ability to automatically lock records (quotes, sales orders, etc.) based on criteria, such as stage. For instance, if a quote has been sent to a client, the quote is then locked for further edits. Our ideal quote stage process is: Draft>Sent>Won.Pass variables to Zoho Desk via URL to create a fast new ticket landing page
We are integrating our phone system into Zoho Desk. Currently when a helpdesk agent answers the phone, a soft client opens a new tab with zoho desk at the new case page. https://desk.zoho.com/support/companyname/ShowHomePage.do#Cases/new We would likeEnhance productivity with the revamped Zoho Sheet View
Hello folks, For some time now, you've been able to use the Zoho Sheet View to quickly edit multiple records or to insert a batch of new records. Its tabular interface allows users to engage in these tasks productively. Despite this, the existing SheetNo OR Filter for Views with a Related Modules Criteria
We would like to create a Deal View where the User can see all their deals. For that, we would need an OR to connect the criteria. One of the Fields is a "multiselect User", these (Related Modules Criteria) can only be Filter with an AND. Even betweenNotes badge as a quick action in the list view
Hello all, We are introducing the Notes badge in the list view of all modules as a quick action you can perform for each record, in addition to the existing Activity badge. With this enhancement, users will have quick visibility into the notes associatedGood news! Calendar in Zoho CRM gets a face lift
Dear Customers, We are delighted to unveil the revamped calendar UI in Zoho CRM. With a complete visual overhaul aligned with CRM for Everyone, the calendar now offers a more intuitive and flexible scheduling experience. What’s new? Distinguish activitiesHow to apply customized Zoho Crm Home Page to all users?
I have tried to study manuals and play with Zoho CRM but haven't found a way how to apply customized Zoho CRM Home Page as a (default) home page for other CRM users.. How that can be done, if possible? - kipi Moderation Update: Currently, each user hasLimit maximum entries for subform - depending on fields entry
Hi Zoho! I have a form with a subform in it. I'd like to have limitation for the row number depending on an entry in a drop-down field in the main form (If the field in the main form is marked "Answer1" - Limit the entries to 1 row, if the field is "Answer2" to have 2 rows limitation, "Answer3" = no limitation at all) Can this be done? Thanks RavidSave HTML Snippet Page as PDF with Dynamic Data in Zoho Creator (Working Solution)
Hi Zoho Creator Community 👋, I faced a common challenge while working with HTML Snippet Pages — I needed to generate a PDF with dynamic data and save it back into the record automatically. Here’s the working solution that might help others. Use CaseHow to loop through Multiple Upload and Display Actual File Name
I have been reading the help on the File Upload Control and reviewed the Deluge help on files and I can not figure out how to loop through the uploaded files and do anything but get the automatically created file names. The code below will run but eachMake Camera Overlay & Recording Controls Visible in All Screen-Sharing Options
Hi Zoho WorkDrive Team, Hope you are doing well. We would like to request an improvement to the screen-recording experience in Zoho WorkDrive. Current Limitation: At the moment the recording controls are visible only inside the Zoho WorkDrive tab. WhenCannot connect to imap.zoho.eu on iOS26
Hey, I recently migrated to another iPhone and since then use iOS26. Every since then, I was not able to connect to "imap.zoho.eu" from Apple Mail. I tried deleting the account and adding it again, did not work. I tried creating an app password, didn'tPieds de page personnalisé - Document Zoho Writer
Bonjour à tous, Je rencontre un souci avec l’ajout d’un pied de page personnalisé dans un document Zoho Writer. Je souhaite insérer les informations de mon entreprise (notamment un logo + adresse) dans le pied de page. Le problème, c’est que lorsque j’ajouteRebranding Options for Zoho One
We need the addition of rebranding and white-labeling settings directly within the Zoho One Admin Panel. This feature should allow organizations to customize the unified portal with their own logo, brand colors, and custom domain mapping (e.g., portal.company.com).Tip #57- Accessibility Controls in Zoho Assist: Mobility- 'Insider Insights'
Remote support should be easy to navigate for everyone. For users with mobility-related accessibility needs, long sessions and complex navigation can be challenging. Zoho Assist’s Mobility Accessibility Controls simplify interaction through keyboard-basedTo print Multiple delivery notes in batches
In Zoho Books, we can print a Delivery Note from an Invoice using the Print Delivery Note option, but it is non-editable and always prints all line items from the invoice. Our requirement is to deliver invoiced items in batches and print delivery notesSocial icons, open in new tab?
Hello, I have two social icons on my footer, Facebook and Psychology Today. Clicking on the Facebook icon opens a new tab, the Psychology Today icon does not. I would like them both to open a new tab. Am I missing a setting somewhere?Open sub form from a button as a popup form
Is there a way within a form to use similar code as below to show a button in the form when clicked opens the subform for data to be added to the record being viewed in the form OpenUrl("#Form:<Customer_Delivery_Address>?<Delivery_Address>=" + input.ID,"popupUPLOAD A CREATED PDF AUTOMATICALLY
Using the html header pdf+print button, I have managed to find a way to have a user create a pdf using entered form data. Using the schedule button, I can have a "file uploaded" pdf mailed to someone as an attachment. The missing piece is to be able to add the pdf, created in that html page to a file upload field automatically? Right now one has to save it to computer and then upload it in a FILE UPLOAD FIELD. Any help would appreciated !Consolidated Department-wise Payroll Cost Summary Report
Hello Zoho Payroll Team and Community, I am writing to discuss a reporting requirement regarding department-level expense tracking within Zoho Payroll. As we scale and manage salary distribution for employees across multiple departments, such as Accounts,Write-Off multiple invoices and tax calculation
Good evening, I have many invoices which are long overdue and I do not expect them to be paid. I believe I should write them off. I did some tests and I have some questions: - I cannot find a way to write off several invoices together. How can I do that,What's new in Zoho Sheet: Simplify data entry and collaboration
Hello, Zoho Sheet community! Last year, our team was focused on research and development so we could deliver updates that enhance your spreadsheet experience. This year, we’re excited to deliver those enhancements—but we'll be rolling them out incrementallyCRM gets location smart with the all new Map View: visualize records, locate records within any radius, and more
Hello all, We've introduced a new way to work with location data in Zoho CRM: the Map View. Instead of scrolling through endless lists, your records now appear as pins on a map. Built on top of the all-new address field and powered by Mappls (MapMyIndia),Easier onboarding for new users with stage descriptions
Greetings, I hope all of you are doing well. We're happy to announce a recent enhancement we've made to Bigin. You can now add descriptions to the stages in your pipeline. Previously, when creating a pipeline, you could only add stages. With this update,How to remove chat icon from knowledge base?
I have set up a knowledge base to hold FAQs and documentation. It is currently standalone, and not integrated into our website. On every page there is a chat button in the bottom left corner that says "We're offline, please leave a message." How can I[ZohoDesk] Improve Status View with a new editeble kanban view
A kanban view with more information about the ticket and the contact who created the ticket would be valueble. I would like to edit the fields with the ones i like to see at one glance. Like in CRM where you can edit the canvas view, i would like to editAutomated Dismissal of Specific Notifications and Centralized Control of Toast Notification Settings
Dear Zoho Team, I hope this message finds you well. We would like to request two enhancements related to notification handling within Zoho Desk: Automatic Dismissal of Specific Notifications: Currently, when certain actions are taken in the ticket listKnowledgebase SEO
We have a custom-domain mapped help center that is not restricted via login. I have some questions: a) will a robots.txt file still allow us to control indexing? b) do we have the ability to edit the sitemap? c) do category URLs get indexed by searchCreate case via email
Good Afternoon, I have just registered and am taking a look around the system. Is it possible to create a case via email. I.e. an employee/client/supplier emails a certain address and that auto generates the case which then prompts a member of staffShow field in spreadsheet view depending on other field value
Hello. Not sure if this is possible but let's say i have spreadsheet view in Creator with four different fields Field A, B, C and D Then i have a field named Response which for one record could contain only one of the pre-definde choices below A, B, CNext Page