# How to do advanced Math Equations

• 0
• Question
• Updated 3 years ago

We are an engineering company and I am looking for a way to do some calculations, that are currently done and stored in excel, within Quickbase.

An example would be

=ATAN((1.452-D2)/1.666)*180/3.1416

Where D2 would be a field in Quickbase.

Is this possible?

• 0 Points

Posted 4 years ago

• 0

Jack, Champion

• 50 Points
I'm not aware of a formula function called ATAN existing in Quickbase. However there is nothing to say that you couldn't perhaps write a formula to perform the function, then apply it to your formula.

((1.452-[Quickbase numeric field name])/1.666)*180/3.1416
• 0 Points
thank you.  In looking into that, would anyone know if/how to use the math function in jscript to pull the parts of the formua from fields, do the arctan and then populate a numeric field with the answer?

for jscript:
Return the arctangent of a specified number:

Math.atan(2)

Ⲇanom the ultimate (Dan Diebolt), Champion

• 30,074 Points
Add a new record and then view the List All report:

https://haversineconsulting.quickbase.com/db/bkgihsdq6?a=q&qid=1

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=461

I only implemented the ATAN calculation on the report page but it could easily be added to the add, edit or view pages.

If you have any other questions about using "Advanced Math" with QuickBase let me know. Right now I am working on applying QuickBase to a Singular Value Decomposition of sales data using Numerijs:

http://www.numericjs.com/documentation.html

I once solved the three-dimensional unsteady form of the Navier-Stokes Equation with QuickBase but I had to use a lot of fields and records to discretize all the points.

https://www.grc.nasa.gov/www/k-12/airplane/nseqs.html
• 0 Points