Forum Discussion
_anomDiebolt_
7 years agoQrew Elite
Follow these steps:
3 * 5 * 7 * 2 = exp( ln(3) + ln(5) + ln(7) + ln(2) )= 210
Then go watch Standard Deviants:
Standard Deviants: Pre-Calculus Module 6 - Logarithms
https://www.amazon.com/Standard-Deviants-Pre-Calculus-Module-Logarithms/dp/B000A2EKTA
- Create a field Ln([Field2]) in the child table (your existing table)
- Summarize this field to the parent field named [SumLog] using addition
- Create a formula field in the parent table named [Product] and set it equal to the formula Exp([Product])
- In the child table lookup the field [Product] from the parent
3 * 5 * 7 * 2 = exp( ln(3) + ln(5) + ln(7) + ln(2) )= 210
Then go watch Standard Deviants:
Standard Deviants: Pre-Calculus Module 6 - Logarithms
https://www.amazon.com/Standard-Deviants-Pre-Calculus-Module-Logarithms/dp/B000A2EKTA
- QuickBaseCoachD7 years agoQrew CaptainThx Dan, I can't imagine when i would need this, but you never know. I tried is on a calculator and it works. I think in a previous life I used to know that.
- _anomDiebolt_7 years agoQrew Elite> I tried is on a calculator and it works.
Of course it works - its just simple math.
As a remedial measure I suggest you binge watch a few seasons of Numb3ers starting with this promo:
He's a mathematician. And He's an FBI agent. And they're both brothers.
https://www.youtube.com/watch?v=EVSFzswY3XY
I created a demo
Multiply Child Fields ~ View [Record ID#]= 1
https://haversineconsulting.quickbase.com/db/bnp7nxxq7?a=dr&r=b&rid=1
There are two formulas - one in the child table where [Ln] is calculated as:
Ln([Number])
and one in the parent table where [Product] is calculated as:
Exp([SumLn])
[SumLn] is a Summary field in Table #1 and [Product] is a lookup table in Table #2.
Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=655
Notes:
(1) you can add your own data to test the application
(2) you can't enter negative numbers as Ln(x) is not defined for negative numbers.