DECIMAL Value1

Help Robot
,
1

Hi Team ,
I am copying one excel Sheet data to another sheet data But its not taking after decimal value , In quantity section,I have given this query for taking opposite of column6
{(-1*Double.Parse(CurrentRow(5).ToString+CurrentRow(6).ToString,System.Globalization.NumberStyles.Any)).ToString(“#,0”)}
0.055 Input
0 is coming as output please help

2

Hi @Kuldeep_Pandey

Can you try this query:

{(-1*Double.Parse(CurrentRow(5).ToString+CurrentRow(6).ToString,System.Globalization.NumberStyles.Any)).ToString("#,0.############")}

Hope this helps,
Best Regards.

3

Thanks Arjun

4

Hi Arjun One Update is there
We are getting , also
41,32 Like this
and its not giving correct output Please help for this also

5

@Kuldeep_Pandey

In that case, please try the following one:

{(-1*Double.Parse(CurrentRow(5).ToString+CurrentRow(6).ToString,System.Globalization.NumberStyles.Any, System.Globalization.NumberFormatInfo.InvariantInfo)).ToString("#,0.############", System.Globalization.NumberFormatInfo.InvariantInfo)}

Best Regards.

6

Is this can work for both case , and . ?

7

Getting different position of comma in output
305,56 input = -30,556

8

Hi @Kuldeep_Pandey ,

If using Modern Design activities, check with the below post, which helps to convert the Number format as required using the Format Cells activity :

Assuming here that only the Number format is the task to be done.

9

Hi @Kuldeep_Pandey

Can you Try this -

{(-1 * Double.Parse(CurrentRow(5).ToString + “.” + CurrentRow(6).ToString, System.Globalization.NumberStyles.Any)).ToString(“#,0.####”)}

Thanks