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
------------------------------