Changes

Jump to: navigation, search

How do I do a count using a sum?

392 bytes added, 14:40, 26 April 2013
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==
8,849
edits

Navigation menu