Forum Discussion
QuickBaseCoachD
7 years agoQrew 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...
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...
- VivekVishwanat37 years agoQrew CadetHi, I din't understand the second line. " Then make a formula on your details table of 1 and make a relationship".
- QuickBaseCoachD7 years agoQrew CaptainYou need to connect every one of your records to hat single record in he new table. The record ID of the single record will be record ID 1.
So just make a formula field with a formula of 1 and use that as the reference field in the relationship on he right hand side. - VivekVishwanat37 years agoQrew CadetYah 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"? - QuickBaseCoachD7 years agoQrew CaptainVivek,
I think that I misunderstood your question. I now see that you want to be able to multiply data from a field in different rows.
I do not think that there is a way to do that with native Quick Base. Native Quick Base can sum a field using a relationship but not multiply it.
Perhaps if you can explain your use case, I can think of an alternative approach. - _anomDiebolt_7 years agoQrew Elite>Native Quick Base can sum a field using a relationship but not multiply it.
use logarithms and exponentiation