Skip to main content
Participant
November 5, 2011
Question

Evaluating a text field as a formula

  • November 5, 2011
  • 1 reply
  • 434 views

Hello World!!

I've been racking my head here lately wondering if this is possible and I'm hoping that someone can tell me it is and how to do it.

Ok here's what I'm trying to do:

I'm trying to create a form that will

1) create new inputs that I call estimates in a table called Estimates

     Definition of table:

     Estimate_ID

     Estimate_Name

     Estimate_Description

     Estimate_formula -- (user defined formula to calucate the estimate)

2) Create multiple inputs per estimate and have these inputs will be stored in a Estimate_Inputs table..(estimate_id will be the key between the two tables)

    Definition of table:

     Estimate_ID

     Input_ID

     Input_name

     Input_type -- (constant, %, etc)

     Input_value -- (user defined)

My end goal is to create a way to store values for a formula in a table and extract them when needed to execute a given formula as defined in Estimates:Estimate_Formula field of another table.

ex. 

     Estimate table:

     Estimate_formula - "= Level_of_Effort - SUNK"

  

     Estimate_Inputs:

     Input_Name - "Level_of_Effort" |  Input_value - 25000

     Input_Name - "SUNK" |  Input_value - 1000

    

     Answer: 24000 =        25000        -   1000

                              "Level_of_Effort" - "SUNK"

    This topic has been closed for replies.

    1 reply

    Inspiring
    November 5, 2011

    Something like this might work.

    Query number 1 - select your formula.  It's now a ColdFusion variable.  Let's call it yourFormula.

    Query number 2

    select field1, field2, #yourFormula#

    from etc