Discussions

 View Only
  • 1.  Formula query for total

    Posted 08-11-2022 14:54
    Edited by Annalise Sansouci 08-11-2022 15:34

    **EDITTED- I figured it out! But now I can't figure out how to delete this post...there is not enough caffeine in the world today...

    Hi All- my brain is fried and I can't figure out this but hoping one of ya'll knows this easy peasy (Looking at your genius Mark Shnier!). Basically I have a table that I want to create a formula query to get totals from another table after a certain date. 

    So there is a total field on one table [Total Ride Cost] and a date field [Date of Ride]. I want it to pull and total all of the total ride costs after April 1 and put that into a second table. 

    Thoughts?



    ------------------------------
    Annalise Sansouci
    ------------------------------


  • 2.  RE: Formula query for total

    Posted 08-11-2022 16:59
    Can you post your successful formula?

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



  • 3.  RE: Formula query for total

    Posted 08-12-2022 08:56
    SumValues(GetRecords("{9.GT.'"&Date(2022, 3, 31)&"'}",[_DBID_RIDES]),11)

    How did I do Mark!?

    ------------------------------
    Annalise Sansouci
    ------------------------------