https://www.infopathdev.com:443/forums/39.aspxNew to InfoPath? Search to see if your question has already been answered. If it has not, then ask it here or the appropriate topic forum.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/3186.aspxThu, 14 Sep 2006 13:42:43 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:3186Shiva0https://www.infopathdev.com:443/forums/thread/3186.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=3186Hi kerri welcome to the forums<br /><br />Whenever we trying to set one value which contains strings or any characters then it shows the validation error like “Only numbers allowed”. Then how you can set this formula for that filed which is data type as “Decimal (double)”. <br />This has the data type as “Decimal (double)” only we can set the decimal places. Both string format (along with %) and decimal places are not possible for one filed.<br /><br />Can you explain me on which field you are setting this formula and data type also?<br />https://www.infopathdev.com:443/forums/thread/1556.aspxTue, 12 Sep 2006 18:58:31 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:1556kerri0https://www.infopathdev.com:443/forums/thread/1556.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=1556I have a field that needs to calculate the percent change of two other fields. I need to display the % symbol in the field with one decimal place. I tried using this formula <br /><br />concat((((field1 / field2) - 1) * 100), "%")<br /><br />with the percentage format, but I don't get any decimal places even though I set the decimal places to 1.<br /><br />Any suggestions?<br /><br />Thanks!