Formulae: Dynamic/evaluated reference to a formula in a field?

fcavalieri · October 29, 2014 9:18AM

Hi,
I'd like to know if it is possible, in a formula field i.e. [Cost_Formula],
to refer to and run a specified formula contained in another text field i.e. [Formula].

I attach a file for example (the exact result I'd like to obtain is the same of Cost field).

Thanks, Franci

tjbate · October 30, 2014 5:59AM

Franci

Not really clear on why you want to do this? If you have multiple formulae and want your file recipients/users to be able to change the basis of the calculation, this can be done with user-selectable Variables in the file, and an IF statement.

In the example attached, the cost calculation can be done 3 ways, depending on the formula chosen by the user.

paola · October 30, 2014 6:07AM

If you wish to re-use formulas from an old file in your new report you can use Data>Formulas>Import/Export functionality
rather than store the formula as text in a table.

Welcome!

Categories

Ideas Parade

Tagged