Forum Discussion

TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
12 months ago

Easy Formula Help

Moving on to my next application.  We keep track of Adobe subscriptions so we can charge the proper departments.  I have the table and such setup, I just need help with the Yearly Cost formula.  I ha...
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
12 months ago

   IF([field 1], 1,0)

+IF([field 2], 2,0)

+IF([field 3], 5,0)

Note that in each if statement it ends with a zero because you don't want the result of the effort to be null because that will wreck the total, and make it blank. 



------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
TonyGonzalez's avatar
TonyGonzalez
Qrew Trainee
12 months ago

Thanks, Mark.  I was able to work it out with a little more time.  End result, for others possible future reference....

Sum(
If([Field1]=true, 676.54, 0)
+If([Field2]=true, 71.64, 0)
+If([Field3]=true, 286.47,0)
+If([Field4]=true, 297.62, 0)
+If([Field5]=true, 297.62, 0))



------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    12 months ago

    Your formula will work fine, what the Sum is superfluous.

    Also when testing a bully and checkbox field that checkbox field is either true or false inherently so you don't really have to test it against true. For example this is the same thing as I originally wrote just more verbose.  I do recognize it's probably easier to read the way you wrote it. (aside form the superfluous SUM(     )

    If([Field1]=true, 676.54, 0)
    +If([Field2]=true, 71.64, 0)
    +If([Field3]=true, 286.47,0)
    +If([Field4]=true, 297.62, 0)
    +If([Field5]=true, 297.62, 0)



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • TonyGonzalez's avatar
      TonyGonzalez
      Qrew Trainee
      12 months ago

      Ah, that makes sense.  It's "smarter" than me, if its a checkbox.  I get it now.  The more verbose option would really work if I was doing this with a multiple choice field.  Right?



      ------------------------------
      Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
      IT Director City of New Braunfels
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        12 months ago

        Yes, exactly.



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------