I have following data set in Fixed Decimal 19.2
I want to increase the precision of the decimal
input:
| Amount |
| -53.61 |
| 57.29 |
| -34.56 |
| 52.68 |
| -46.9 |
| -6.3 |
Expected output:
the end datatype should be in Numerical
| -53.61 |
| 57.29 |
| -34.56 |
| 52.68 |
| -46.90 |
| -6.30 |
@BRRLL99 if you look at the below WF i just set the data type to Fixed decimal 19.2 and got the desired result.
Im using
Version: 2022.3.1.553 Patch: 6
if i convert to 19.2 fixed decimal
it is giving me 46.9
and 6.3 only
please share your screen shot
| Amount |
| -53.61 |
| 57.29 |
| -34.56 |
| 52.68 |
| -46.9 |
| 100 |
| -6.3 |
Expected Output:
in my end output i would like to remove point and negative sign
the datatype should be Numerical
I have tried different ways , but unable to get the expected output, i have checked the show numerical separator in results also
| Amount |
| 5361 |
| 5729 |
| 3456 |
| 5268 |
| 4690 |
| 100 |
| 630 |
