Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: Dynamic/evaluated reference to a formula in a field? - Visokio Forums
Formulae: Dynamic/evaluated reference to a formula in a field?
  • fcavalieri October 29, 2014 9:18AM
    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

    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.


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership