UNSOLVED
D
DavidHampson
2 Intern
•
1080 Posts
0
217
May 8th, 2009 07:00
Count up number of items in EBA
I am sure there is an easy way to do this...
I have 4 columns and I want the report to show three columns and the total number of corresponding entries of the fourth column (a text field), but there does not seem to be an operator that will allow me to do a count of the fourth column and leave the other three columns.
To do this I have added a dummy field (integer) which I have assigned the value 1 then used the Group By operator grouping by the 3 columns I want and set default number operation to sum.
This works fine but I am sure this is something pretty standard which should have a simpler way of achieving my end... Any ideas?
I have 4 columns and I want the report to show three columns and the total number of corresponding entries of the fourth column (a text field), but there does not seem to be an operator that will allow me to do a count of the fourth column and leave the other three columns.
To do this I have added a dummy field (integer) which I have assigned the value 1 then used the Group By operator grouping by the 3 columns I want and set default number operation to sum.
This works fine but I am sure this is something pretty standard which should have a simpler way of achieving my end... Any ideas?
