Skip to main content
Question

how to calculate the exponential formula of a summary column

  • October 31, 2019
  • 0 replies
  • 99 views
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • October 31, 2019
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
------------------------------
Mark Shnier. Your Quickbase Coach
AdamKeever1
Forum|alt.badge.img+2
  • AdamKeever1
  • Quickbase Alumni
  • October 31, 2019
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
------------------------------
Terms & ConditionsAccessibility statement