I have 4 columns in a grid. I need the value in the second column divided by the

I have 4 columns in a grid. I need the value in the second column divided by the 3rd column and entered in the 4th column. So if 10000 is the second value and the 3rd column is 400 I need the 4th column autocalculated to 25. See the attached screenshot for assistance.

Divide values in grid.gif

OriginalPostID-139290

OriginalPostID-139290

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Since non-SAIL forms don't have the ability to dynamically update values, you'll to do this through a form submission. A solution for this case could be having a button at the bottom of the form saying "Calculate Hourly Costs", and using that button will submit the form, chain through a script task that calculates the hourly costs, and then chains back to the form.

    To the end user it doesn't look like they left the form, and now the hourly costs are updated.
Reply
  • 0
    Certified Lead Developer
    Since non-SAIL forms don't have the ability to dynamically update values, you'll to do this through a form submission. A solution for this case could be having a button at the bottom of the form saying "Calculate Hourly Costs", and using that button will submit the form, chain through a script task that calculates the hourly costs, and then chains back to the form.

    To the end user it doesn't look like they left the form, and now the hourly costs are updated.
Children
No Data