Hi Forum Members,
I’m new to RPA and finding difficulty in one of my modules. Please do assist!
I have a Data table named in_dteob—it has columns (Slno, DOS, ProcCode, SubmittedCharge, AllowedAmount, Invoice)
when the invoice and proc code is matching with the application, I have to do the below subtraction
I’ve declared the variables for submittedcharge and allowed amount as string.
when I’m trying to do the subtraction I’m receiving the attached error. It would be helpful if someone assisted me.
Below is the Condition I used
in_dtEOB.AsEnumerable().Where(Function(x) x.Item(“Invoice”).ToString.Contains(in_Invoice) And x.Item(“ProcCode”).ToString.ToLower.Trim.Contains(strChkCPT.ToString.ToLower.Trim) And convert.ToDecimal(x.Item(“ChgAmt”).ToString)-convert.ToDecimal(x.Item(“AllowedAmt”).ToString))
Attached Error Snapshot
Thanks in Advance
dtEOB.xlsx (8.4 KB)