Skip to main content
A
Alex198813-Aquamarine
13-Aquamarine
January 25, 2018
Question

Sending small value weight to Windchill ESI

  • January 25, 2018
  • 1 reply
  • 1146 views

Hi all,

 

We have a small issue when sending to SAP parts with small weight values. For example if you set the weight at 0.0000000001 then to SAP (in the windchill ESI Response files) the value 1.0E-12 is sent. 

SAP cannot process this so we should have 0.0000000001 sent. 

 

Any ideas?

 

Alex

1 reply

C
Casey_Swain14-Alexandrite
14-Alexandrite
May 9, 2018

I think you could do this by capturing the value after the "E" into a variable, and then parse the string using this as a feeder to a pad function in combination with concatenation.  It would work but be a really messy formula.

 

Alternatively, you could parse the string into the value before "E" as a number variable, the value after "E" as a number variable, and calculate a new number variable = N1/(10*N2) and convert that back to a string.

The second approach might be easier.

 

Casey

 

Terms & ConditionsCookie settingsAccessibility statement