Forum Discussion

PushpakumarGna1's avatar
PushpakumarGna1
Qrew Assistant Captain
6 years ago

how to calculate the exponential formula of a summary column

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
------------------------------
  • 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
    ------------------------------
    • PushpakumarGna1's avatar
      PushpakumarGna1
      Qrew 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
      ------------------------------
      • PushpakumarGna1's avatar
        PushpakumarGna1
        Qrew Assistant Captain
        Yes, its kind of power function. here the base is "e" of value 2.71

        ------------------------------
        Pushpakumar Gnanadurai
        ------------------------------
  • 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
    ------------------------------
    • PushpakumarGna1's avatar
      PushpakumarGna1
      Qrew Assistant Captain
      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
      ------------------------------