Forum Discussion

ChrisBreault's avatar
ChrisBreault
Qrew Member
2 years 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 ...
MikeTamoush's avatar
MikeTamoush
Qrew Elite
2 years ago

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