Adding Decimal upto 2 digit in whole number

Help Studio
, ,
1

Hi All,

I am trying to add decimals on whole number with below formula but doesnt seem to be working.
Number = Cdbl(String.Format(“{0:0.00}”,Number)
Number value is saved as Double

Few examples:
Input Output
100 100.00
155 155.00
278.91 278.91

Kindly help. Thank you.

2

Hi,

Please check the below code. let me know if you need more information.

Decimal.xaml (5.2 KB)

1 Like
3

Hi @skg_161125 ,

Try like this

CDbl(Number).ToString(“#####.00”)

4

Hi

Give a try with FORMAT VALUE activity
It would help you in this case

image

Cheers @skg_161125

1 Like
5

Thanks @ghazanfar, you solution worked. Only thing I was doing differently is saving Number variable in existing number variable (Double) after adding decimal. In your solution, you saved updated value in h(String) variable.
Thanks for your help.

1 Like
6

Thank you @ermanoj3101 for you solution as well.

7

Thanks @Palaniyappan: I tried Format Value, but i was not sure if I will have comma separator or decimal separator in my input values or not.

8

Thanks for updating code :slight_smile:
You can modify it according to your scenario …

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.