AnsweredAssumed Answered

Calculated Fields Parsing Numbers

Question asked by stuart.holding on Jun 25, 2015
Latest reply on Dec 11, 2015 by baltner

I have an issue with the calculated value control whereby it will parse the calculation result as an integer despite my explicit declaration that it to "save as data type" as a string. The reason this is a problem is because I want to use the value of the calculated field later in the form to filter another drop down control.

 

When I configure my calculated value control with the following formula to retrieve the first 3 chars of my drop down (after parsing the lookup and getting the value)

substring3.PNG

I correct am returned a value of "02:"

substring3output.PNG

 

However if I change the formula to return just the first 2 chars of the same drop down value

substring2.PNG

I am presented with a calculated value control value of "2". It's as though, despite as above I'm saying store the value as a string (I want to maintain the prefix of 0 if it's there) it is parsing it as an int.

substring2output.PNG

 

Does anyone know a workaround for this?

Outcomes