Difference between revisions of "How do I do a count using a sum?"
From SmartWiki
Line 9: | Line 9: | ||
==Examples== | ==Examples== | ||
− | [[Image:ReportBuilderExample1.PNG|link=| | + | [[Image:ReportBuilderExample1.PNG|link=|300px]] |
[[Category:FAQ]][[Category:Reports]] | [[Category:FAQ]][[Category:Reports]] |
Revision as of 09:59, 26 April 2013
Q: How do I do a count using a sum?
A: if([this]='Counting Criteria',1,0)
Why do we do this?
When using the Criteria line in the Report Builder, one line of criteria is treated as a single AND statement. By using this method we can move the criteria up to the Calculate Field area and allow for multiple OR criteria using a singular AND statement in the Criteria line.