calculate two fields to variance result

[Former Community Member]

I've got 2 numeric fields called "on record" and "physical count". "on record" field is pre-populated and the user enters the new number in the the "physical count" field. The number of "physical count" can be more or less than "on record" field. I'd like the result in the variance to calculate either plus or minus.

and there will be grand total in the bottom of the "variance" column. Here is the image that shows the fields in the table.

Please help with this script

Thanks for your help!!!

~ jbazum

[Former Community Member · Accepted solution]

Take a look at the attached. Tweak the variance calculation, if necessary.

Steve

[Former Community Member]

Thanks again Steve!!! It worked.

[AnakDajal]

dou you have scrript for text field in php, I have the sam problem