How to substarct between decimal value and get exact output

[roysupriya21 (Supriya Roy)]

Hello,

I have an excel file where I have debit column and credit column. my requirment is I have to substract Credit - Debit

please check my excel file.
500900_02122021_TrialBalance.xlsx (9.6 KB)

in Debit column I have value 30059.25 and in Credit column I have value 248880.00

now my problem is when i made substraction it is showing 218821
but my output should be 218820.75
To substract from credit i have write below code

cint(row.Item(“Credit”))-Cint(row.item(“Debit”))
but it is giving 218821 as output.

please suggest me how I can get exact substraction value

thanks in advance.

[prasath_S]

Hi @roysupriya21

Please try below,

cdbl(row.Item(“Credit”))-Cdbl(row.item(“Debit”))

Thanks

[Srini84 (Srinivas Kadamati)]

@roysupriya21

One way of doing that is as below

Hope this will help you

Thanks

[roysupriya21 (Supriya Roy)]

but I have to get the exact output which is 218820.75

[Srini84 (Srinivas Kadamati)]

@roysupriya21

Then no need of Balance Split step

Check as below

Thanks

[roysupriya21 (Supriya Roy)]

Kindly send me the test workflow.

[Srini84 (Srinivas Kadamati)]

@roysupriya21

I’m working on new uipath version, so you may experience some issues

Share us with your workflow, we can make modifications and reupload

Thanks

[roysupriya21 (Supriya Roy)]

substraction.xaml (6.5 KB)
please check my workflow.

[roysupriya21 (Supriya Roy)]

I have modified my workflow as your suggestion. it is working now. thank you