brain fog question

[Stella001]

I am using mercator version 7.5
I have a customer sending me a number ( ex 999 ). I need to load this into a text field making it a decimal ( ex 9.99 ) . I know this is probably an very easy question but for some reason my brain is fogged over this morning.

 

[Mags1972]

Will it always be mapped across to 2 decimal places? or will it sometimes be 3 or even none??

 

[Stella001]

It will always be 2 decimal places

 

[janhes]

left(field,size(field)-2)) + "." + right(field,2)

 

[janhes]

Sorry missed the input is a number.
left(numbertotext(field),size(field)-2)) + "." + right(numbertotext(field),2)

 

[Stella001]

thank you, I will try that.

 

[Stella001]

Thank you. worked perfect