Error in calculated field with respect to decimal points

Question & Answer
, ,
1

Hi Community , I’m trying to create dynamic decimal control which changes the decimal places according to the parameter i’ve created
but when i click on decimal 1, the decimals are changing in the numeric field but there are extra zero’s coming
how Do i resolve it?

2

Hi @Vysh27,
in you table you are using the test6 field, right?
BR

3

yes @ErikG ,
When I’m converting the sum(data) to string that’s where there are 4 auto decimals coming up

4

how do I trim the extra decimals from it?

5

left(toString(sum(Data)),locate(toString(sum(Data)),".",1)+1)
the +1 define how many decimal you want.

6

Thanks @ErikG , it’s working

7

Please mark the topic as solved.