# Discussions

View Only

## how to calculate the exponential formula of a summary column  #### Mark Shnier (YQC)11 days ago   #### Mark Shnier (YQC)11 days ago  • #### 1.  how to calculate the exponential formula of a summary column

Posted 11 days ago
Hi All

Basically , I am trying to calculate the exponential value of a summary column.

Consider , i am summarizing the total of marks and then need to find the exponential value of total of marks

Exp(sum(marks))  - should be my one of the report formulas

Can you please help me. For example if the total is 1.23 (which is a summary total of my marks column) , I expect my report formula that is exp(sum(marks) as 343 but i get 645

Thanks

------------------------------
------------------------------

• #### 2.  RE: how to calculate the exponential formula of a summary column

Posted 11 days ago
Can 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
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

• #### 3.  RE: how to calculate the exponential formula of a summary column

Posted 11 days ago
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

------------------------------
------------------------------

• #### 4.  RE: how to calculate the exponential formula of a summary column

Posted 11 days ago
Yes, its kind of power function. here the base is "e" of value 2.71

------------------------------
------------------------------

• #### 5.  RE: how to calculate the exponential formula of a summary column

Posted 11 days ago
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
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------

• #### 6.  RE: how to calculate the exponential formula of a summary column

Posted 11 days ago
Edited by Adam Keever 11 days ago
You can do this with a one to many relationship and a summary field. Student Marks table has [Students] & [Marks] fields. Student Mark Summaries Table has [Students] & [Exponent] fields. Relate the two as follows:  Then import data into the tables:

Student Marks: Student Mark Summaries: Then create the exponent formula in [Exponent] field of Student Mark Summaries table: ------------------------------
------------------------------

• #### 7.  RE: how to calculate the exponential formula of a summary column

Posted 10 days ago