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 ...
Formulas and functions
Relationships
reports and charts
AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years 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
------------------------------
  • PushpakumarGna1's avatar
    PushpakumarGna1
    Qrew Assistant Captain
    6 years 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
    ------------------------------