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 11 days ago
    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 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
    Your Quick Base Coach
    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




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



  • 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

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



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