Updating sum of subform

Updating sum of subform

I encountered another problem for updating of sum of fields in a subform.


on a main form (Make_claim), I have a dynamic drop down (approved_budget_purpose) list to which filters the the items display in a subform (expense_claim_history1). 

In the subform, I have a field "expense_amount1", which i want to total up in the field " total_expense_claimed1" in the main form.

In my drop down list, I have 2 items 
1) Buddha Day
2) Mother's Day

When I choose Budhhas Day, the subform will be populated with 1 item as below
1) expense amount: 4,000

When I choose Mother's day, the subform will be populated with 3 items as below
1) expense amount: 4,000
2) expense amount: 2,000
3) expense amount: 3,500


Scenario 1
Step 1 -> Choose Buddha Day in dropdown list
The total_expense_claimed1 = 4,000 (as expected)

Step 2 -> Change to Mother's Day in the dropdown list
The total_expense_claimed1 = 13,500 (I am expecting 9,500)

Step 3 -> Change to Buddha Day in the dropdown list
The total_expense_claimed1 remains 13,500 (It does not change to 4,000)

From then on, no matter what i choose on the dropdown list, the total_expense_claimed1 remains 13,500, although the subform is displaying the correct no. of items as expected for both choices in the drop down.

Scenario 2
Step 1 -> Choose Mother's Day in dropdown list
The total_expense_claimed1 = 9,500 (as expected)

Step 2 -> Change to Buddha Day in the dropdown list
The total_expense_claimed = 13,500 (I was expecting 4,000)

Step 3 -> Change to Mother's Day in the dropdown list
The total_expense_claimed remains 13,500 (It does not change to 9,500)

From then on, no matter what i choose on the dropdown list, the total_expense_claimed remains 13,500, although the subform is displaying the correct no. of items as expected for both choices in the drop down.


My code is as below, triggered by user input of approved_budget_purpose (i,e. Budhha Day, Mother's Day)

  1. clear expense_claim_history1;
  2. row1 = Make_claim.expense_claim_history1();
  3. //
  4. expense_history = Make_claim[claim_type == "Expense" && approved_budget_purpose == input.approved_budget_purpose && pv_no != ""];
  5. for each  expense in expense_history
  6. {
  7. row1.pv_no=expense.pv_no;
  8. row1.expense_amount1=expense.total_cost;
  9. //
  10. subformrow = Collection();
  11. subformrow.insert(row1);
  12. input.expense_claim_history1.insert(subformrow);
  13. }
  14. tot = 0.0;
  15. for each  rec in input.expense_claim_history1
  16. {
  17. tot = tot + rec.expense_amount1;
  18. }
  19. input.total_expense_claimed1 = tot;
  20. // input.total_expense_claimed1 = expense_claim_history1.sum(expense_amount1);


I have been trying to resolve this for 2 hours...

Can anyone help?


    Zoho Desk Resources

    • Desk Community Learning Series


    • Digest


    • Functions


    • Meetups


    • Kbase


    • Resources


    • Glossary


    • Desk Marketplace


    • MVP Corner


    • Word of the Day


      Zoho CRM Plus Resources

        Zoho Books Resources


          Zoho Subscriptions Resources

            Zoho Projects Resources


              Zoho Sprints Resources


                Zoho Orchestly Resources


                  Zoho Creator Resources


                    Zoho WorkDrive Resources



                      Zoho Campaigns Resources

                        Zoho CRM Resources

                        • CRM Community Learning Series

                          CRM Community Learning Series


                        • Tips

                          Tips

                        • Functions

                          Functions

                        • Meetups

                          Meetups

                        • Kbase

                          Kbase

                        • Resources

                          Resources

                        • Digest

                          Digest

                        • CRM Marketplace

                          CRM Marketplace

                        • MVP Corner

                          MVP Corner




                          Zoho Writer Writer

                          Get Started. Write Away!

                          Writer is a powerful online word processor, designed for collaborative work.

                            Zoho CRM コンテンツ






                              ご検討中の方

                                • Recent Topics

                                • Stop adding Default ID column to xls exports

                                  When anything is exported to xls, Zoho adds a column with an ID.  WE DO NOT WANT THIS COLUMN.  We use an automated report to a team.  We have our own tracking number.  1. This makes the report messy, it just pushes OUR data off to the right.  2. We have
                                • Request for Alerts on Workflow and Function Changes.

                                  I want to get an alert whenever a new workflow or function is added or an existing workflow or function is edited. Is there any way to do that? I need to log all changes whenever updates are made or new ones are added.
                                • Overwrite Option for custom modules

                                  Hi Team, I noticed that the overwrite option is unavailable in Zoho Books when importing data for custom modules. This limitation makes it challenging to bulk update old data, as the only option is the 'bulk update' feature, which is restricted to 25
                                • Transfer Amount from One Vendor to Another Vendor

                                  One of the vendors, who has a balance with us, has closed the business and has started a new business; Now he wants me to transfer the outstanding from the old account to the new Vendor Account. I am trying to do this using Payment Settlement a/c, But
                                • Been getting this error, every now and then "Get count limit exceeded, please try again after 3 mins"

                                  it is really annoying.
                                • How to make Branch compulsory in Zoho Books invoice?

                                  How I make Branches compulsory in Zoho Books invoice?
                                • Regarding GST Report Issue in Zoho Books

                                  Hi, Right now, the very important point from my end is this Zoho Books issue. Here, you can see that we have created the invoice with the items of account sales and expenses. The journal is also correct. The profit and Loss statement is also correct.
                                • Function #57: Automatically group items in invoices based on categories

                                  Hello everyone, and welcome back to our series! As a business expands and new product lines are launched, it becomes important to organize the items for better inventory management. The Category field in Zoho Books helps here by allowing you to add and
                                • Is the Contacts sync between Campaigns and CRM bi-directional?

                                  Is the Contacts sync between Campaigns and CRM bi-directional?
                                • Fixed asset management

                                  I want to know if there is any individual module for fixed assets management
                                • Customise Search Bar in CRM

                                  Is there a way to customise this search bar in the CRM to add fields?
                                • Suppress "spreadsheet will not be saved" message on published sheet

                                  I have published a sheet and have one column on that sheet that the user can edit (a dropdown picklist where the user can select the status for each line). Is there a way to suppress the Zoho Sheet message "Any changes made to this published spreadsheet
                                • Privacy error

                                  Privacy error on Chrome for all embedded forms and reports, this is a huge issue: "Your connection is not private Attackers might be trying to steal your information from creator.zohopublic.com (for example, passwords, messages, or credit cards). NET::ERR_CERT_COMMON_NAME_INVALID"
                                • Zoho Forms Unable to Save Account Numbers with a Leading Zero

                                  We are using Zoho Forms to for rental applications. It is working well, except for one thing:  when a user enters their bank account information, and that account number actually starts with a ZERO (like 00123456) the Zoho form will return the value without
                                • Profit on Sales order

                                  Hi, would it be possible to implement a column at the Sales order overview of Purchase amount? So a field with the amount of all purchase related to this Sales order? This is very usefull so you will see the profit you made on this deal. I tried to get
                                • How to include GST% in PO amount?

                                  Currently when I raise PO, the basic price of the item is used. However, the GST is not calculated and added along with the basic amount. I have added a Custom field for GST in the PO but I need Zoho Inventory to calculate the GST amount and add it with the Basic price to give me the final PO price.
                                • No Sales Returns on SO's with Dropped Shipped items + Inventory Items

                                  We have encountered an issue in Zoho related to sales orders that include both dropshipped items and inventory items. Specifically, it is currently not possible to create sales returns for the company’s own inventory items from these sales orders. This
                                • sitemap in zoho sites not updating

                                  I checked my sitemap and it has not added any updates. Do I have to generate one manually all the time or is zoho sites suppose to generate and update it?
                                • I trying to connect our PM tool but API shows failure

                                  Hi All, in ZOHO CRM when an enquiry stage is moved to WON then I have created a rule to trigger POST URL to thrid party AP and then create a function for mapping with below code void automation.kytesfunctions(String enquiryId) { // Fetch enquiry details
                                • 2 serial numbers for 1 item (Mac address and Serial number)

                                  There is a way to track 2 serial number type for 1 Item. Ex: Some electronic devices have a MAC address and a serial number. I need to track those 2 numbers
                                • Sample Ticket - Created from Bot Preview

                                  Why is Zoho desk adding bot created tickets?
                                • Webhook data is not being received

                                  We’ve set up the webhook with a public URL that returns a 200 status on Postman. However, when we ran a test, we didn’t receive anything in the req.body object or see any data from the POST request. As a team of freshers still learning the ropes of development,
                                • Finding draft ticket replies

                                  Is there a way to see all tickets which have draft replies?
                                • Number of Workflow runs

                                  Is there a way in Zoho desk to see statistics regarding workflows, rules and other automation objects? Would be nice for several reasons: You could ensure that your workflows are actually running. You could determine which ones weren't being used so you
                                • Mail is no longer populating CRM contacts

                                  Hi! For the last few days, my mail hasn't been populating my CRM contacts. Even people I email multiple times per day. In fact, it keeps trying to send mail to myself. Notice, I started typing Amy and only got as far as, "Am" and it suggested myself.
                                • Zoho Support is indeed shocking and difficult to get a response with

                                  All our business emails have an auto-foward set up on them so that they also go to our GMAIL accounts so that we receive them to the relevenat people. The emails are indeed auto forwarding and arriving to our GMAIL accounts but when you log into your
                                • New Search Function

                                  Hey Team, The search function updated in our CRM about a week ago, so I assume it was an automated update across Zoho. It no longer displays leads/deals etc in Chronological order so that the most recently created or updated is the first to display which
                                • Unable to load your extension. Please check your plugin-manifest or Resources.json.

                                  Hi Team, I am using the config module with multiple fields of different types, such as checkboxes and picklists. However, I am encountering the following issues: Error Message: When loading the extension, I get the error: "Unable to load your extension.
                                • is it possible to add more than one Whatsapp Phone Number to be integrated to Zoho CRM?

                                  so I have successfully added one Whatsapp number like this from this User Interface it seems I can't add a new Whatsapp Number. I need to add a new Whatsapp Number so I can control the lead assignment if a chat sent to Whatsapp Phone Number 1 then assign
                                • Not able to change colors help center

                                  Hi. How can I change the orange color in the help center? You can change everything besides this font color And how can I remove the part on the bottom?
                                • Chart with Filtered Data vs Unfiltered Data

                                  I am looking to create a chart view that displays the full data set vs a subset of the data filtered by user filter. However I do not seem to find any method by which to exclude a plot from the applied filter or any other method by which to display the
                                • How to get a list of selected records into a button-function? Here is how!

                                  So, you might know already how to get a button on a page somewhere and perform actions with a function when pressed, but how about a button that only works with the records you selected in the list view? The button selected is a custom button in the modules
                                • How to Add Break line / Return on button click

                                  I need to return the text concate with difference field from lead with line break i try "\r" ,"\n" "<br>" return "ali \r\n <br> baba"; None of above work.  i expected result something like this  ali baba but got this  ali \r\n <br> baba so, how can i
                                • How to get batch number of item by api?

                                  Hi there, Is there any way to get batch number of item by api? Batch number is the batch reference number in https://www.zoho.com/inventory/help/advanced-inventory-tracking/batch-tracking.html . When I call the https://www.zoho.com/books/api/v3/#Items_Get_an_item
                                • Automatically assign Contacts to Account owners

                                  Hi, I have a finite number of accounts set up in the CRM, and each new contact that comes in is automatically assigned to an Account according to a rule I set up. I want the Contact owner in the Contacts module to be assigned to the relevant Account owner.
                                • Filter embedded report

                                  How to filter embedded report in a page, below code is not working. dateField => startDate & dateField=< endDate The report should print on page containing records from startDate to endDate. params='zc_Header=true&amp;Service_Date__gte=<%=startDate%>&amp;Service_Date__lte=<%=endDate%>'
                                • Serious question: Are there actually "solo-preneurs"/small business owners who made Zoho-one work well for them?

                                  L.S. After already many years of continued struggle with Zoho-One, I am seriously wondering if there are actually solo-preneurs (one person small business owners - without a large, dedicated IT dept.) who got it (Zoho-One) to work well for their businesses.
                                • Announcing new features in Trident for Windows (v.1.18.6.0)

                                  Hello Community, Trident for Windows is here with some new features to elevate your workplace communication. Let's take a quick look at what's new. Ask and send read receipts for emails You can now request read receipts for specific emails while composing,
                                • Increase subscription prices for existing subscriptions

                                  Hi, Does anyone know how we could achieve the ability to increase the subscription fee for our existing customers based on a % increase. We are not yet using Zoho Billing (Subscriptions) and I'm not sure if it is a good fit for us. But we would need to
                                • Why developing custom function development made so difficult for Zoho Projects!!

                                  Hi Zoho Team, I am trying to write function to automate a process but whatever API name or Column Name I use, the API isn't populating certain fields. Even the standard fields aren't getting populated through API. It's already exhausting to find all API
                                • Next Page