Calculated Properties

Properties can store data entered manually or via upload, or the property value can be calculated from other properties within the same step. Calculated properties can be evaluated during data export or by a manual trigger and are denoted in design mode by a "calculator" icon to the right of the property name.

Screen_Shot_2018-01-17_at_10.42.20_AM.png

To configure a calculated property, add a property to a step and then click the calculator icon to the right of the property name. This will open the "Create/Edit Property" modal which allows you to specify the formula used for the calculated property. There are two type of formulas that can be configured for calculated properties: formulas and export only formulas. 

Formulas

Properties with calculations that can be manually triggered in an experiment can be configured from the formulas tab. This tab allows the target value or actual value to be calculated from property values, resource names, or property specifications (target, usl, lsl) on the any step. In measure mode, the calculation of these properties is manually triggered.

Formulas can be used to build dynamic and responsive feedback into your Riffyn process without the need for a spreadsheet or external calculation tool.

Screen_Shot_2018-01-17_at_10.49.35_AM.pngFormulas that are used across steps use values on linked runs. If a variable on another step is referenced, it will not be valid unless runs on the current step are connected to the referenced step. If multiple runs are merged or split and used as reference for a formula variable, the mean value across those runs will be used for numeric data. For non-numeric data, the first value will be used.

A list of supported formula operators and restricted variable names can be found here. Formulas can work across multivalued data when using the run summarization feature. 

Export Only Formulas

Step 2 of the "Riffyn: Measure Absorbance" process contains an export only formula for "Dilution Factor". Export only formulas are built from the actual values on properties within the same step. Each Property is assigned a variable name, with variable names being used to build the calculation formula:

Screen_Shot_2018-01-17_at_10.43.35_AM.png

Export only formulas are limited to basic mathematical operations, and work across multivalued data.

If properties or resource types assigned to a variable change in your process, the calculator icon next to the property will turn red indicating an error in formula, which should be checked for accuracy.

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.