<div>
Not sure what do you mean by &quot;sum the string&quot; - put them all together side by side or perform a actual SUM function on the values?<br />
If you just want to concatenate all data you can add a new filed that contains the value from all these 4 fields combined together.
</div>


<div>
To clarify, I want to sum all the &quot;1&quot; values. &nbsp;For example, the value I would like to be calculated from my data example above would be &quot;54&quot; as there are fifty four instances of the number 1.
</div>


<div>
What reporting tool are you using?<br />
<br />
mlmcc
</div>


<div>
Method 2 did the job! Thank you so much for answering my question and helping me learn! :)
</div>


<div>
<div class="content wysiwyg-content">
I have four fields that are all 144 char in length and data type is String. &nbsp;The value is either 0 or 1 with no separating characters or spaces, and I want to sum the string. &nbsp;Data example is:<br />
<br />
00000000000000000000000000<wbr />0000000000<wbr />0000000000<wbr />0000000000<wbr />0000000000<wbr />0000000000<wbr />0000000000<wbr />0000111111<wbr />1111111111<wbr />1111111111<wbr />1111111111<wbr />1111111111<wbr />11111111<br />
<br />
Thank you in advance for your assistance!<br />
<br />
BethS
</div>
</div>


I have four fields that are all 144 char in length and data type is String.  The value is either 0 or 1 with no separating characters or spaces, and I want to sum the string.  Data example is:

000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000111111111111111111111111111111111111111111111111111111

Thank you in advance for your assistance!

BethS

Not sure what do you mean by &quot;sum the string&quot; - put them all together side by side or perform a actual SUM function on the values?
If you just want to concatenate all data you can add a new filed that contains the value from all these 4 fields combined together.

To clarify, I want to sum all the &quot;1&quot; values.  For example, the value I would like to be calculated from my data example above would be &quot;54&quot; as there are fifty four instances of the number 1.

What reporting tool are you using?

mlmcc

Method 2 did the job! Thank you so much for answering my question and helping me learn! :)

sum String field values of 0 and 1 in Crystal Reports

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.