I now create [nearly] all formulae in 2 DM blocks:
the first adds all formulae which I want to treat as if they were data values read, or merged, from my data source(s) and does NOT carry these through as formulae (the default setting)
the second adds all the formulae which I want to use as formulae in my model, and so I set the "Preserve formulae in output" option
I say nearly all formulae, because the exception is any formula which involves the use of a variable. There is no way of referencing a variable in the formula editor within the DM environment (from a Field organizer block).
Could we please have a means of referencing variables inside DM? It's so much more manageable to keep all field work inside DM, and this is the only remaining omission AFAIK.
We have now added support for variables in DataManager.
Variables can edited in the "Field organiser" block. To edit the variables click the "Tools" button at the bottom of the block and select "Edit variables...".
Any variables you create will be available to use in the formula editor.
Make sure you select "Preserve formulas/variables in output" in the block options.
Please let us know if you encounter any problems or have any questions.