How to add numeric fields together | Community
Skip to main content
F
fogharty-1
September 9, 2021
Solved

How to add numeric fields together

  • September 9, 2021
  • 3 replies
  • 1803 views

I knew how to do this once, but have now forgotten.

 

I have a form where I need to sum the values from 7 fields into an 8th one.

I've tried using JavaScript and FormCalc and tried all sorts of scripting examples but I can't make it work.

Perhaps I have the fields buried too deep inside sub sub forms?

I know it should be a basic thing to do, but my brain is just not working right now.

I'd appreciate any help.

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Lavanya_Pejjayi

Can you try changing it to "antiracism" or "anti_racism" under the subform "grandchallengesyessf"

Sum(antiracism, quantumscience, climateresilence, scienceliteracy, earlychildhood, sustainablefood, healthequity)

 

from 

 

Sum(anti-racism, quantumscience, climateresilence, scienceliteracy, earlychildhood, sustainablefood, healthequity)

 

I hope this will help.

3 replies

radzmar
radzmar
September 9, 2021

In FormCalc you can use the Sum() method i the calculate event of the total field. Just add the names of the fields to be summarised.

 

Sum(anti-racism, quantumscience).
    F
    fogharty-1Author
    September 9, 2021

    I'm doing something wrong, since I'm getting an error message.

    With FormCalc, run at Client...

     

    form1.titlesponsorsf.titlesponsordatasf.grandchallengessf.grandchallengesyessf.totalpercentages::calculate - (FormCalc, client)

     

    Sum(anti-racism, quantumscience, climateresilence, scienceliteracy, earlychildhood, sustainablefood, healthequity)

     

      Lavanya_Pejjayi
      Adobe Employee
      Lavanya_PejjayiAdobe EmployeeAccepted solution
      Adobe Employee
      September 13, 2021

      Can you try changing it to "antiracism" or "anti_racism" under the subform "grandchallengesyessf"

      Sum(antiracism, quantumscience, climateresilence, scienceliteracy, earlychildhood, sustainablefood, healthequity)

       

      from 

       

      Sum(anti-racism, quantumscience, climateresilence, scienceliteracy, earlychildhood, sustainablefood, healthequity)

       

      I hope this will help.

        Kosta_Prokopiu1
        Adobe Employee
        Kosta_Prokopiu1Adobe Employee
        Adobe Employee
        September 13, 2021

        the others have spotted the issue with the field name. 

        Generally: Never use operators such as "-" or "+" in a field name even if Designer does not prevent you from doing so. Latest in scripting will this fall on your toes. If you want to structure your field names use "_" or camel case like quantumScience ...

          F
          fogharty-1Author
          September 15, 2021

          Thank you all for your help.

          It is greatly appreciated!

            Terms & ConditionsAccessibility statement

            Loading footer...