How do I do a count using a sum?
From SmartWiki
Revision as of 08:59, 26 April 2013 by Arthur Lathrop (talk | contribs)
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.
Examples
