## Advanced operator in the Formula Column Window

Modified on: Wed, 10 Oct, 2018 at 5:53 PM

abs(A) = returns the absolute value of a number

avedev() = average deviation

***

floor(A)= The floor function of a real number x, sometimes called the greatest integer or entire function

***

exp(A,B) = Exponent of a number

fact(A)= Factorial of a number

***

One might desire to 1) take the average deviation of vacancies of X number of floors, or 2) know what the value of X to the 2 power would be in a report because the floor space or the head count might grow from 20 to 400. That would be exp(20,2) = 400. This gives the mathematically minded the means of providing mathematical calculations and reporting on them.

Did you find it helpful? Yes No

Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.