Forum Discussion
MarkShnier__You
Qrew Legend
6 years agoCan you give an example with three child record values and how you want the calculation done. You say Exponential value - what exponent? squared, like the power of 2?
Also are you trying to calculate Std Deviation?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Also are you trying to calculate Std Deviation?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
PushpakumarGna1
6 years agoQrew Assistant Captain
Hi Mark,
Exp is the Exponential function in Maths where the value of "e" is 2.71828 (related to logarithms)
Lets think we have data like this
student marks
A 5
A 6
B 7
B 8
If i try to create a summary of marks based on student then the summary would look like
A 11
B 15
Now , i am trying to generate the third column (user formula in the summary report ) which is Exp(sum(Marks))
so the expected result is
A 11 59874.141
B 15 3269017.372
Note : If i create a column Sum(Marks) it works but not Exp(sum(Mark))
Thanks
------------------------------
Pushpakumar Gnanadurai
------------------------------
Exp is the Exponential function in Maths where the value of "e" is 2.71828 (related to logarithms)
Lets think we have data like this
student marks
A 5
A 6
B 7
B 8
If i try to create a summary of marks based on student then the summary would look like
A 11
B 15
Now , i am trying to generate the third column (user formula in the summary report ) which is Exp(sum(Marks))
so the expected result is
A 11 59874.141
B 15 3269017.372
Note : If i create a column Sum(Marks) it works but not Exp(sum(Mark))
Thanks
------------------------------
Pushpakumar Gnanadurai
------------------------------
- PushpakumarGna16 years agoQrew Assistant CaptainYes, its kind of power function. here the base is "e" of value 2.71
------------------------------
Pushpakumar Gnanadurai
------------------------------- MarkShnier__You6 years ago
Qrew Legend
For the value of A mathematically, e11th (59,874) is equal to
e5th times e6th (148 * 403)
But right now I cannot think of how Quick Base can multiply across records.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------