Forum Discussion

AweMaggie's avatar
AweMaggie
Qrew Trainee
9 months ago

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.  



------------------------------
Awe Maggie
------------------------------

6 Replies

  • 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
    ------------------------------
    • AweMaggie's avatar
      AweMaggie
      Qrew Trainee

      Thanks! 

      See the attached screenshot



      ------------------------------
      Awe Maggie
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

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