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 LEDlike 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.
Comments
You can follow this conversation by subscribing to the comment feed for this post.