8,849
edits
Changes
→Examples
===Counting Records where End Date is After a Given Date===
[[Image:ReportBuilderExample2.PNG|link=|300px]]<br>
This calculation will assign a value of "1" to each record where the End Date is later than April 1, 2013, and a value of "0" to all other records, and then sum up the list, returning a total of all records for which the End Date is later than April 1, 2013. ===Counting Records where Text Field contains a Given Text String===[[Image:ReportBuilderExample3.PNG|link=|300px]]<br>This calculation will assign a value of "1" to each record where the Description field contains the word "laptop," and a value of "0" to all other records, and then sum up the list, returning a total of all records where the Description field contains the word "laptop."
==See Also==