Forum Discussion

ChrisBreault's avatar
ChrisBreault
Qrew Member
3 months ago

Adding totals across multiple database entries ?

Hello,

New to quickbase here. I'm trying to add totals of two different fields of specific service types.

Ex: Service type contains Either "Reconstruction" or "Dry Out" and adding these two sums together and only showing the ones where the sum is over the specified amount.

Any and all help is greatly appreciated.

Thank you.



------------------------------
Chris Breault
------------------------------

13 Replies

  • Can you explain what fields you have?

    Is this correct?

    Service Type
    Amount Field 1
    Amount Field 2

    If so, make a formula numeric field:

    var number TotalAmount = [Amount Field 1] + [AmountField 2];

    If(
     ([Service Type] = "Reconstruction" or [Service Type]= "Dry Out") and $TotalAmount > XXX,
    $TotalAmount
      )



    ------------------------------
    Mike Tamoush
    ------------------------------
    • ChrisBreault's avatar
      ChrisBreault
      Qrew Member

      There's a field that has Service Types that's labeled "Service Type" the two types of data that need to be combined are Reconstruction and Dry Out. 

      Service Type    Earned

      Reconstruction    AmountX
      Dryout            AmountX

      I'm trying to combine the dryout and reconstruction totals and only show the ones that are greater than or equal to 1100 in a new report or filter.



      ------------------------------
      Chris Breault
      ------------------------------
      • MikeTamoush's avatar
        MikeTamoush
        Qrew Commander

        OK near as I can tell the Service Type is irrelevant here.

        You can simply make a formula numeric field called [Dryout and Reconstruction Total] where the formula is simply:

        [Reconstruction] + [Dryout]

        Then in a report, under filters:

        [Dryout and Reconstruction Total]  is greater than or equal to the value 1100



        ------------------------------
        Mike Tamoush
        ------------------------------