Skip to main content
Report with Country 1 (includes all countires) & Amount (converted) columns. Is it possible to create a filter a formula so that the report will exclude opportunities below $100k for Germany & United & below $50k for other countries
8 件の回答
  1. 2013年8月15日 14:21
    This would be advanced report filters with filter logic. You'll need to create 3 filters one for opportunities:

     

    1. Amount greater than $100,000

     

    2. Country is Germany or United States

     

    3. Amount greater than 50,000

     

    Then add Filter Logic be selecting "Filter Logic" from the report filter picklist option. You will get a type of formula field that will allow you to group filters. It will start as "1 AND 2 AND 3" but you'll want to edit it to read "(1 AND 2) AND 3." This will group the the 100K and Germany/US requirements while applying the 50K to all opps.