I dynamically populate rows of data. I need to get the amount due for a line item.
Items from DB:
OriginalAmount = Dollar amount owed
totalPayment = How much has been paid so far.
txtAmtPatientPaid = input box
txtAmtPaid = input box
If I only subtract the amount from the DB it works but now I need to subtract the two input box fields. How can I do the calculation below? I believe I need to change the field type to a number but I don't know how.
dblAmtDueTemp = FormatNumber(rd("OriginalAmount") - rd("totalPayment") - Request.Form("txtAmtPatientPaid" & i) - Request.Form("txtAmtPaid" & i), 2)