the Dynamic Formula Tool:
The Dynamic Formula Tool allows you to dynamically create formulas using a data feed. Effectively allowing you to write formulas by using other formulas, the summarize tool or other techniques. Great for when you need to write a long or complex formula or create a lot of formulas and don't want to do it manually.
The tool takes two inputs:
The data input which is your main data feed as you would normally pass into a standard formula tool.
The formula input which is a data feed which contains the information which you would normally enter into the properties pane of the standard formula tool.
There are 4 configuration properties which map the fields in the formula input to the corresponding fields in the formula tool.
Version 1.0 - Initial release.
Version 1.1 - Increased length of formula fields to allow for longer dynamic formulas.
Version 2.0 - Updated to 8.5 layout. Fixed bug with XML metacharacters in formulas < > & ". Checked "Output fields change base on the data input into the macro". Added versioning macro. Added online help. Updated icon.