# Discussions

View Only

## how to calculate the exponential formula of a summary column  #### Mark Shnier (YQC)10-31-2019 12:22   #### Mark Shnier (YQC)10-31-2019 13:23  • #### 1.  how to calculate the exponential formula of a summary column

Posted 10-31-2019 10:47
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 10-31-2019 12:22
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 10-31-2019 13:01
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 10-31-2019 13:04
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 10-31-2019 13:23
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 10-31-2019 13:31
Edited by Adam Keever 10-31-2019 13:34
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-31-2019 22:04