Skip to Content
author's profile photo Former Member
Former Member

display the one that occurs the most

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2008 at 04:12 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 04, 2008 at 04:26 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.