Operators and Functions in Autodesk Navisworks Quantification

One of the questions Daniel Fahmi asked on our blog recently was around formulas in Navisworks Quantification, rather than just share this with Daniel, we thought more of you may want to know what formulas can be used in Quantification: -

Here is the full list of operators and functions supported in Navisworks Quantification: 

Operator	Description
+	Plus
-	Minus
*	Multiply
/	Division
%	Percentage(E.g. =10% gives "0.1")
(	Left parenthesis
)	Right parenthesis
>	Greater than
>=	Equal or greater than
<	Less than
<=	Equal or less than
<>	Not equal
=	Equal sign
^	Power
,	Comma
&	String concatenation

Function Name	Description
abs	Mathematical function.
acos	Mathematical function.
asin	Mathematical function.
atan	Mathematical function.
atan2	Mathematical function.
ceiling	Mathematical function.
cos	Mathematical function.
cosh	Mathematical function.
exp	Mathematical function.
floor	Mathematical function.
log	Mathematical function.
log10	Mathematical function.
max	Mathematical function. For example, max(a, b, c, …)
min	Mathematical function. For example, min(a, b, c, …)
power	Mathematical function.
pi	Mathematical function. For example, pi()
true	Logical function. For example, true()
false	Logical function. For example, false()
exp	Mathematical function. For example, exp(1)
round	Mathematical function.
sin	Mathematical function.
sinh	Mathematical function.
sqrt	Mathematical function.
tan	Mathematical function.
tanh	Mathematical function.
if	Checks whether a condition is met, and return one value if TRUE, and another value if FALSE. For example, if(a>b, c, d)
sum	Mathematical function, adds all the numbers. For example, sum(a, b, c, …)
average	Mathematical function, return the average of input numbers. For example, average(a, b, c, …)
convert	Convert unit, return a new value according to source and target unit. For example, convert (fromUnit, toUnit, value). Convert syntax is like Convert("m","in", 3.0) – units are specified as string constants.

* For logical operators, only True() and False() are supported. And, Or, Not are not supported.

Change statuses

It's also worth noting that the status icon has various combinations of 4 LED-like lights

	Deleted	Takeoff object's model object was deleted in the model.
	Erroneous	Takeoff object has an equation error (usually, a circular reference).
	Changed	Takeoff object's model object has one or more changed property values (since the last time the takeoff object was updated from the model).
	Overridden	Takeoff object has one or more overridden property values.

Not all of these are valid for any single takeoff object.  For instance, a takeoff object cannot be both changed and deleted at the same time, since the takeoff's model object is missing (and there is therefore no way to tell if there are changed property values).  However, these indicators are used at the Item level as well to give a summary for all of the Item's takeoff objects.  In that case, you might well see "changed" and "deleted" at the same time: the Item is telling you it has at least one changed object and one deleted object.