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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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)