Forum Discussion

VivekVishwanat3's avatar
VivekVishwanat3
Qrew Cadet
7 years ago

How to multiply all the record values of a Field?

Field1     Field2 1             3 2             5 3             7 4             2 I need to do 3*5*7*2=210 And I want to show the result as Field1     Field2       Field3  1         ...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
You will need to create a new table in the app with a single record in it. It will be Record ID 1.


Then make a formula on your details table of 1 and make a relationship.


Then make a sum of a field which multiplied the two numbers.


That is called the �dot product�.

https://en.m.wikipedia.org/wiki/Dot_p...
VivekVishwanat3's avatar
VivekVishwanat3
Qrew Cadet
7 years ago
Yah but, How can I make a formula of Multiplication "3*5....." in the formula Field. As 3 and 5 are from different rows?
And What exactly you are saying when you are saying "formula of 1"?