One of the features we are occasionally asked for - that we do support within Clarity, and recently noticed it was missing from the documentation, is the ability to do calculations within a datasheet.

For example, you have the "Target Area" and the "Actual Area", but what if you wanted to show the percentage?

To do so, you can use the EVALUATE keyword.

EVALUATE takes a statement inside of curly braces { } - and runs it through a C# evaluation tool.

The EVALUATE step happens AFTER it has already "parsed" in the various parameter values. For example:

EVALUATE{[Room:Area]/[Room:TargetArea]*100}

Other