About 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.

Configuration Properties:

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 History:

  • 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.