<div>
<div class="content wysiwyg-content">
I Have a SP 2010 custom list and I am trying to created a calculated variable that is the first character of an existing filed IF the field does not start with &quot;D&quot;<br />
<br />
here is my current calculated field formula<br />
<br />
=LEFT([Q2 Score],1)<br />
<br />
I need to add something that sets &quot;D&quot; to &quot;0&quot; when the first character is &quot;D&quot;
</div>
</div>


I Have a SP 2010 custom list and I am trying to created a calculated variable that is the first character of an existing filed IF the field does not start with "D"

here is my current calculated field formula

=LEFT([Q2 Score],1)

I need to add something that sets "D" to "0" when the first character is "D"

SharePoint Custom List Calculated Value ?

Microsoft Sharepoint is a software platform and family of software products used for collaboration and web publishing combined. These capabilities include developing web sites, portals, intranets, content management systems, search engines, wikis, blogs, and other tools for business intelligence and collaboration. SharePoint has a Microsoft Office-like interface, and it is closely integrated with the Office suite.