What would be the best way to SUM fields together? What I'm trying to figure out is how to add multiple fields for the user together.

If I had the 3 user fields below:
cb_uservalue1   with a stored value of 100
cb_uservalue2   with a stored value of 200
cb_uservalue3   with a stored value of 300

How would I display a field that essentially takes the SUM (cb_uservalue1),(cb_uservalue2),(cb_uservalue3) and stores/displays a value of 600 and updates with any change of the cb_uservalue field?

I do really well building and working inside of Community Builder, but my PHP, SQL, and coding skill is only a very marginal step above illiterate.

I would be grateful to learn how to accomplish the above, and ecstatic to learn how to do that "live" as the fields are changed on screen.... but one step at a time i guess. 

 

I was able to implement the Code Field and php you suggested and it works perfectly to display the SUM. I was able to use it in multiple areas and even adjusted to code to do some different math here and there, thank you.

However, I do have one instance where I need that SUM result to be shown as a field in a downloaded report. I have users downloading reports returning database columns to a csv, and without the SUM being stored as its own field in the database, the SUM result is not shown in the downloaded report.

I can tell that Auto Action could be pretty powerful, but for the life of me, I can not figure out how to use it. 

I am using a 3rd party extension that is sql based. I'd love to find a way to inside CB, because I'm more familiar with that. 

In my CB field "cb_amicode", which sums the fields for display (which works great), I tried adding the following code which would also store the value in another field "cb_amitest", before displaying the sum result ... but not luck with that working.: 

I don't think I can use the AutoAction>Field Type because the math is a little more than just adding two fields. Really it's adding 1 group of fields and then adding 2% of the result of another group that was previously summed. It works great in PHP code to display it, but seems AutoAction>Field Type wouldn't handle the more complex code that the Code field can handle.

I'm going to work with it tonight with ChatGPT to try it get some PHP code for my field that is displying it to also ?POST? or ?SET? it into another field. I don't see why PHP couldn't do that...just my limited experience requires me the lean on A.I. it help code it.