Getting Started

 View Only
  • 1.  How to use sum formula

    Posted 12 days ago

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


  • 2.  RE: How to use sum formula

    Posted 12 days ago

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



  • 3.  RE: How to use sum formula

    Posted 12 days ago
      |   view attached

    Thanks! 

    See the attached screenshot



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



  • 4.  RE: How to use sum formula

    Posted 12 days ago

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



  • 5.  RE: How to use sum formula

    Posted 12 days ago

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



  • 6.  RE: How to use sum formula

    Posted 12 days ago

    No worries.  I got it.  

    Thanks! 



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



  • 7.  RE: How to use sum formula

    Posted 12 days ago

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