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
    Looks like this is a non SAIL form - you'd need to change to SAIL to be able to do the suggested. If you can't change to SAIL are you allowed to use javascript? You could try creating javascript rules for this. If not you could split the form into 2 one for entering the Cost and Billable Hours another that then shows the Cost per Hour with the ability to move back to the data entry screen if needed.
Reply
  • 0
    Certified Lead Developer
    Looks like this is a non SAIL form - you'd need to change to SAIL to be able to do the suggested. If you can't change to SAIL are you allowed to use javascript? You could try creating javascript rules for this. If not you could split the form into 2 one for entering the Cost and Billable Hours another that then shows the Cost per Hour with the ability to move back to the data entry screen if needed.
Children
No Data