Variable calculation from excel

Help StudioX
,
1

Hi,
I want to calculate with two variable which I got from excel with " read cell value". It calculates well with the numbers but when it comes to numbers with decimals results are not correct.
image

image

image

image

How can I solve this?
Thanks in advence.

2

You have not shared the output if you are getting error or just a wrong/unexpected value. I would guess that the problem with your excel that the decimal symbol being used is comma (,) as expected in european format. Try to read the values first as string, replace the comma with a period then convert it to double datatype before you do the calculation.

1 Like
3

Hi @anil.candan

Instead of doing with numbers try to do with double or decimal
In your case, in What to write field in Write cell activity, try like this,

CDec(Hz_EUR)/CDec(Hz_EUR_Fiyat)

Hope it helps!!

1 Like
4

Dear @mkankatala , Dear @avejr748,
Both solitions worked together :slight_smile:
Thank you very much for your kind support.
Regards.

2 Likes
5

Thank you @anil.candan

If you find the solution, make my post mark as solution to close the loop.

Happy Automation!!