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.
Solved! Go to Solution.
Views
Replies
Total Likes
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.
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).
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)
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.
Remove the dash (-) fron the field name.
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 ...
Thank you all for your help.
It is greatly appreciated!
Views
Likes
Replies
Views
Likes
Replies