Process validation on a row/field without user interaction

Leslie,
To answer your question, I am not aware of a way to fire a validation with out some sort of action. However, I think you have some options to look at to accomplish what your looking for.

One option would be to have a validation check on your current price field. Include the variance calculation and logic to check if it is to high or low there. This is what the SAIL Recipe that Sonal shared is doing. This is probably the cleanest option for the end user.

Another option you could consider is to have form level validation instead of field level. So when you add the current price, you calculate the difference as planned. Then when you try and submit, it could have validation on the derived field.

Another option I can think of is to have another column in the grid that indicates the status and have it calculated at the same time you do the variance column. This approach will not prevent the user from submitting the form though. This is the approach Shyam is getting at.

Leslie,
To answer your question, I am not aware of a way to fire a validation with out some sort of action. However, I think you have some options to look at to accomplish what your looking for.

One option would be to have a validation check on your current price field. Include the variance calculation and logic to check if it is to high or low there. This is what the SAIL Recipe that Sonal shared is doing. This is probably the cleanest option for the end user.

Another option you could consider is to have form level validation instead of field level. So when you add the current price, you calculate the difference as planned. Then when you try and submit, it could have validation on the derived field.

Another option I can think of is to have another column in the grid that indicates the status and have it calculated at the same time you do the variance column. This approach will not prevent the user from submitting the form though. This is the approach Shyam is getting at.