Results 1 to 2 of 2

Thread: [RESOLVED] CR11 Formula

Threaded View

  1. Mar 26th, 2007, 09:51 AM #1
    Mark Gambo
    Mark Gambo is offline

    Thread Starter
    Giants World Champs!!!! Mark Gambo's Avatar
    Join Date
    Sep 2003
    Location
    Colorado
    Posts
    2,965

    Resolved [RESOLVED] CR11 Formula

    I want to create pie chart on a report but I only want to the chart to display (count) certain items on the report. So I created a Formula Field:

    CR Code:
    1. If {CarType} = "Ford" Then {CarModel}


    When the Chart is displayed all of the "Ford" Models appear on the chart but one additional slice appears which are the Non-Ford vehicles. How do I only display the "Ford" Vehicles?

    Sample Data
    Type-Model
    Ford-E450
    Ford-Crown Vic
    Ford-Taurus
    Chevy-Lumina
    Jeep-Wagoneer
    Ford-F150

    Thanks!
    Last edited by Mark Gambo; Mar 26th, 2007 at 10:10 AM.
    Regards,

    Mark

    Please remember to rate posts! Rate any post you find helpful. Use the link to the left - "Rate this Post". Please use [highlight='vb'] your code goes in here [/highlight] tags when posting code. When a question you asked has been resolved, please go to the top of the original post and click "Thread Tools" then select "Mark Thread Resolved."

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width