I have to count data that are less or equal to a number in one column and to count data that are greater than that number to another column. Any solution anybody?
| <=80 | >80 |
| count data <=80 | count data>80 |
*This post is locked for comments
an example:
You can also use the Sum function for conditional aggregate calculations. For example, if a dataset has a field that is named State with possible values Not Started, Started, Finished, the following expression, when placed in a group header, calculates the aggregate sum for only the value Finished:
=Sum(IIF(Fields!State.Value = "Finished", 1, 0))
follow for this link for details
Share
Report
All responses (
Answers (
47,688
