display the one that occurs the most

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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