AnsweredAssumed Answered

PDM round to two decimal places

Question asked by Stephen Bouxsein on Jun 24, 2019
Latest reply on Jun 25, 2019 by Jim Steinmeyer

On a template card i want to input a number in inches in a text box and convert it to mm in another box using the multiply function but round the result to two decimal places.  I have a function (this was in place before I became an admin) which rounds the mm result to one decimal place, but I cannot quite figure out how to round to 2 places. I am looking for advice on how to change this code to get the result I want.

 

$Token($Mul(%TESTINPUT%,25.40)|$Add($LEFT($Add($Mul(%TESTINPUT%,25.40),$Mul($Token(1|0|0|0|0|0,$Sub($Len($Mul(%TESTINPUT%,25.40)),$Add($Find($Mul(%TESTINPUT%,25.40),.),1)),|),0.01)),$ADD($FIND($Add($Mul(%TESTINPUT%,25.40),$Mul($Token(1|0|0|0|0|0,$Sub($Len($Mul(%TESTINPUT%,25.40)),$Add($Find($Mul(%TESTINPUT%,25.40),.),1)),|),0.01)),.),3)),$Mul($Token(-1|-2|-3|-4|5|4|3|2|1,$Right($LEFT($Add($Mul(%TESTINPUT%,25.40),$Mul($Token(1|0|0|0|0|0,$Sub($Len($Mul(%TESTINPUT%,25.40)),$Add($Find($Mul(%TESTINPUT%,25.40),.),1)),|),0.01)),$ADD($FIND($Add($Mul(%TESTINPUT%,25.40),$Mul($Token(1|0|0|0|0|0,$Sub($Len($Mul(%TESTINPUT%,25.40)),$Add($Find($Mul(%TESTINPUT%,25.40),.),1)),|),0.01)),.),3)),1),|),0.01)),$Add($Div($Add($Find($Mul(%TESTINPUT%,25.40),.),1),$Add($Find($Mul(%TESTINPUT%,25.40),.),1)),1),|)

Outcomes