Discussions

Expand all | Collapse all

how to calculate the exponential formula of a summary column

  • 1.  how to calculate the exponential formula of a summary column

    Posted 10-31-2019 10:47
    Hi All

    Can you please help me on this

    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

    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------


  • 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
    Your Quick Base Coach
    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




    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------



  • 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

    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------



  • 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
    Your Quick Base Coach
    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 add the summary field:

    Then import data into the tables:

    Student Marks:

    Student Mark Summaries:

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


    ------------------------------
    Adam Keever
    ------------------------------



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

    Posted 10-31-2019 22:04
    hi Adam ,

    Thanks a lot for your reply. Here i have multiple columns to get the summary. But these columns are just the part of the key value.

    But i will think in these lines and see if i can do this.

    Thanks

    ------------------------------
    Pushpakumar Gnanadurai
    ------------------------------