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)


I correct am returned a value of "02:"



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


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.



Does anyone know a workaround for this?