Calculations in Clarity Datasheets

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 cool things it can do:

  • Logical tests   ([Room:Area]>500)   => True
  • Conditionals with IIF  =>   IIF([Room:Area]>500,'Large','Small')
  • Logical operators  =>   [Room:Area]>100 AND [Room:Perimeter]<300  => True
  • Substring =>  Substring('[Room:Number]',1,5) 

See:

https://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression(v=vs.110).aspx

Follow
Was this article helpful?
0 out of 0 found this helpful
Reply