Forum Discussion

AnnaliseSansouc's avatar
AnnaliseSansouc
Qrew Member
2 years ago

Formula query for total

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

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    2 years ago
    Can you post your successful formula?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • AnnaliseSansouc's avatar
      AnnaliseSansouc
      Qrew Member
      2 years ago
      SumValues(GetRecords("{9.GT.'"&Date(2022, 3, 31)&"'}",[_DBID_RIDES]),11)

      How did I do Mark!?

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