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/100630.aspxFri, 02 Jan 2015 10:20:11 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:100630sicky0https://www.infopathdev.com:443/forums/thread/100630.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=39&PostID=100630Hi All, <br /> I was wondering if someone knew how to create a calculated field that is base-36? <br /><br /> Basically im trying to update our asset lists. <br /> because we use Dell laptop we keep a close eye on the service tags, to put it short. <br />We have one field ( dell_service_tag ) then we have another field (dell_express) both of these need to be filled in, however what we would like to do is do a calculated field (base-36) on the dell service tag. <br /> in excel id use the following calculation<br /><br /> =IF(M130=&quot;&quot;,&quot;0&quot;,SUMPRODUCT(POWER(36,LEN(M130)-ROW(INDIRECT(&quot;1:&quot;&amp;LEN(M130)))),(CODE(UPPER(MID(M130,ROW(INDIRECT(&quot;1:&quot;&amp;LEN(M130))),1)))-48*(CODE(MID(M130,ROW(INDIRECT(&quot;1:&quot;&amp;LEN(M130))),1))64)))) <br /><br /> where M130 would be the Dell_service_tag