Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Talend Cloud AWS EU Scheduled Outage: Starting Tues 26 May 21:00 CEST with expected completion Wed 27 May 01:00 CEST
cancel
Showing results for 
Search instead for 
Did you mean: 
griffin2571
Contributor
Contributor

How to add a decimal to second to last digit

I am trying to add a decimal to the second to last digit on the parts order column. For example Parts Order  is

PARTS +0080 I am trying to convert to PARTS +008.0

How do I change the format for this?

griffin2571_0-1667509887105.png

 

 

 

Labels (4)
1 Solution

Accepted Solutions
MarcoWedel

Left([Parts Order],Len([Parts Order])-1)&'.'&Right([Parts Order],1)

View solution in original post

1 Reply
MarcoWedel

Left([Parts Order],Len([Parts Order])-1)&'.'&Right([Parts Order],1)