Online Database Formulas and Functions

TrackVia Advantage

Track sales through a "year-to-date" field that sums totals across all months. When you update the sales total for one month, you'll notice the year-to-date total updates automatically. Want to track average monthly sales? With TrackVia, you can do it in a few clicks of your mouse!

View an example of this feature.

Calculate with the ease of a spreadsheet!

With TrackVia, you don’t need to move your information out of the database to make calculations – we let you do it right in the database!

It’s easy to create “calculated fields” by adding formulas that perform various mathematical functions across database fields. You can even perform formulas on short answer fields to combine text values.

Examples of Predefined Functions:

Sum
Average
Median
Absolute
Minimum
Maximum
Random
Floor
Ceiling
Square Root
Exponential
Factorial
Distance Between Zips

Round
Round Up
Round Down
Natural Logarithm
Common Logarithm
Remainder/Modulo
Sine
Cosine
Tangent
Degrees
Radians
Date Formulas
Logic Functions