on 11-04-2008 3:51 PM
Hi,
I want to summarize a field that would display the one that occurs the most.
Would the Nth most frequent, where N is 1 work for this?
Just want to make sure I'm not missing anything.
Thanks,
Z
Hi Zack,
Use the summary type as Mode.
For more information on Mode see the crystal help for Summary and Mode.
The following examples are applicable to both Basic and Crystal syntax:
Mode({Customer.CUSTOMER NAME})
Returns the mode (the most frequently occurring value) for the Customer Name field.
Mode({Customer.CUSTOMER NAME}, {Customer.REGION})
Groups values in the Customer Name field by region, and then returns the mode for the Customer Name field, per region.
Mode({Customer.CUSTOMER NAME}, {Customer.REGION}, "monthly")
Groups values in the Customer Name field by region, then returns the mode of the Customer Name field for each region, per month.
Hope this helps..!
Regards,
Aditya Joshi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Zack,
To summarise the field that occurs most you need to use the running total.
--use the field in running total
--use the formula for evaluation like mode()=
--No reset condition
If you have any groups in your report then
--use field in running total
--use the formula for Evaluate like mode(,{grouped field})=
--reset on change of group and select the group
Regards,
Raghavendra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.