How to get leading zero in calculated value field


Hi,

I'm using Classic forms.

I have two calculated value controls inside a repeating section. These controls use  a list item property called "Division Code" inside the formula. The Division Codes look like 098,067 with  a leading zero. But the calculated value control does not return the leading zero in its output. They look like 98xxxx without the leading zero. 

 

I have used the "Save as data type" as string as well in the calculated value control. 

 

Any suggestions as to how to get the leading zero from the calculated value control.

 

Regards,

KaviRana


3 replies

Userlevel 6
Badge +22
Hi,

This is strange.
I just tested this and yes the leading zero was being trimmed but when I changed the Save as data type to string the leading zero was not trimmed.

Hi @SimonMuntz ,


 


Did you try that on a responsive form or Classic?


 


I'm using classic forms on O365.


 


 


Regards,


KaviRana

Userlevel 6
Badge +22
Hi,

I tested in both Responsive and Classic and found in both that setting the Save as data type to string kept the leading zero.

Reply