Can the new calculation widget do table lookups?

  • Profile Image
    Asked on March 19, 2014 at 11:17 AM

    Will the form calculator be able to do table lookups?  I would like to have the widget supply a number based on looking up ranges of numbers and then doing a calculation.  For example, if the number is between 5500 and 7500, then the result would be 660 (the result from the table for that range) plus 15% of the amount greater than 5500.  This would allow tax calculations, although the formula would be much more complex than this example.

    Also, would you be able to then take that number and do a new calculation based on the result from another table?


  • Profile Image
    Answered on March 19, 2014 at 03:02 PM


    We've updated our calculation widget and include advance math functions. You can find the references here: Form Calculation - Math Function Reference

    One question, how would you intend to implement the table? Is it using the Text Box field? Do you have some sort of example on how this work to the form? OR maybe, tell us the whole flow?


  • Profile Image
    Answered on March 19, 2014 at 05:53 PM

    I am a family law attorney and I intend to use this to allow child support calculations.

    The client would enter his or her gross income and other information and the program would deduct the appropriate taxes and other deductions and then from that result, calculate the amount of net available income that would be applied in the case.

    The program would then use that number and calculate the actual support based on a table depending on the number of children involved in that case and the number of children not involved in thiat case.  Each circumstance has a different percentage of support.

    An alternate way to do it would be using a large number of "if...then..." statements.  If the case involves 3 children and the obligor has one other child that he is responsible for then the support will be X percent of net available income.

  • Profile Image
    Answered on March 19, 2014 at 10:32 PM

    As you stated on your last post, I also believe this would be possible using conditional rules so that the the calculation is made depending on the initial value that was input by the user. To be straight forward I lack the knowledge of how child support is calculated, but I would think that the best process would be to allow the user to input their main variables at first, to avoid conditional rules further down the calculation.

    As my colleague stated above, it would be helpful to have an example of what is needed to work this on a form. So that we may assist you better. 

    Thank you.