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.
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.
Thanks!
See the attached screenshot
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.
