Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

How to add numeric fields together

fogharty
Level 2
Level 2

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.

Screenshot 2021-09-09 150311.jpg

 

1 Accepted Solution
Lavanya_Pejjayi
Correct answer by
Level 3
Level 3

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.

View solution in original post

6 Replies
radzmar
Level 10
Level 10

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).
fogharty
Level 2
Level 2

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)

 

error message.jpg

Lavanya_Pejjayi
Correct answer by
Level 3
Level 3

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.

View solution in original post

Kosta_Prokopiu1
Employee
Employee

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 ...

fogharty
Level 2
Level 2

Thank you all for your help.

It is greatly appreciated!