Datasheets: Published Ordered Knowledge Base: : Clarity | IMAGINiT Support Published Ordered Knowledge Base: Datasheets Helprace RSS https://imaginit.helprace.com/s2-clarity/knowledgebase/top/c7-datasheets?format=rss 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[_cuted_]

]]> Tue, 09 Jul 2019 18:07:38 +0000 https://imaginit.helprace.com/i152-calculations-in-clarity-datasheets https://imaginit.helprace.com/i152-calculations-in-clarity-datasheets Matt Mason Matt Mason 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

]]>