Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Question Unanswered: Using the Select Expert to limit formula fields

    I have created a formula within my report to calculate Net Margin and ideally I would like to be able to limit the records to certain groups.

    Example: I would like to show only those records where the Net Margin is < 15%. How can I do this in Crystal since it does not allow you to use the Select Expert to limit on formula fields you have built. Any help is greatly appreciated.

  2. #2
    Join Date
    Aug 2002
    Use the TOP N feature to return your dataset

    goto Report|TOP N sort group

    Add the group you want to return the top % for your query


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts