Skip to main content
Question

Adding totals across multiple database entries ?

  • March 6, 2024
  • 0 replies
  • 358 views

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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+20
  • Registered
  • March 6, 2024

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