How to use sum formula
I am trying to use the sum formula and the formula is looking for the number, but the data field types I was trying to add are numeric with dropdown number options. ----------------------------...
Forum Discussion
You should be able to create a field of type formula numeric (ie not simply numeric).
If you say in words what your calculation needs to be we can help you with the specific syntax.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks!
See the attached screenshot
------------------------------
Awe Maggie
------------------------------
OK, I see the screenshot and you were showing me a bunch of numeric fields. Are you now asking how to make a new formula numeric field which uses those fields in its calculation? Are you stuck on the formula for that numeric formula field? If you can say the formula in words we can help you with the syntax. Or if you have a formula which is not working and you copy and paste it (not a screen shot, but a copy paste) we can help de-bug the formula.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------I am trying to create a sum formula to add these four fields.
" A new formula numeric field which uses those fields in its calculation."
------------------------------
Awe Maggie
------------------------------No worries. I got it.
Thanks!
------------------------------
Awe Maggie
------------------------------You will find that you can just do it similar to excel and you don't need to use SUM.
Just
[field 1] + [field 2] + field 3] + [field 4]
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
