Difference between revisions of "How do I do a count using a sum?"
From SmartWiki
m |
|||
Line 6: | Line 6: | ||
''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.'' | ''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.'' | ||
+ | |||
+ | ==Examples== | ||
+ | |||
+ | [[Image:ReportBuilderExample1.PNG|link=]] | ||
[[Category:FAQ]][[Category:Reports]] | [[Category:FAQ]][[Category:Reports]] |
Revision as of 09:58, 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.