+ Start a Discussion
Nisha BabuNisha Babu 

Admin Beginner  Reports & Dashboards :getting error Challenge Not yet complete... here's what's wrong:

Hi all ,
The question is Create a report to show opportunities that are greater than the amount specified below. Note: Because this challenge includes a USD currency filter, you may need to update your personal preferences. Go to My Settings | Personal | Language & Time Zone and change the Locale to English (United States) and the Language to English and click Save.
Name the report 'High Value Opportunities' and save it to the 'Unfiled Public Reports' folder.
The new report should be of type Opportunities.
The report format should be tabular.
The report should show all opportunities, of any status or probability, with any close date.
The report should include these columns: Opportunity Name, Type, Amount, Close Date, Stage, and Opportunity Owner.
The report should have filters for opportunities of an Amount greater than $25000 USD and opportunities where the Stage is not equal to Closed Won or Closed Lost.
If you delete your report and empty your recycle bin, the report name 'High Value Opportunities' won't be available anymore. Don't worry! Just add a number to the end of the report (e.g., 'High Value Opportunities1').

The output I got
The generated report for the opportunities


Error I am getting:
Challenge Not yet complete... here's what's wrong:
Please check that you have a filter for Stages that are not equal to Closed Won or Closed Lost.

But Actually I have included the filters for that, Please check the picture.

With Regards,
  Nisha



 
Best Answer chosen by Nisha Babu
Amit Chaudhary 8Amit Chaudhary 8
Please check below post. I hope that will help you
1) https://developer.salesforce.com/forums/?id=906F0000000BOGHIA4
2) https://developer.salesforce.com/forums/?id=906F0000000BIZEIA4

Your Filter should be like below
User-added image


How to select
User-added image

Let us know if this will help you.


 

All Answers

Amit Chaudhary 8Amit Chaudhary 8
Please check below post. I hope that will help you
1) https://developer.salesforce.com/forums/?id=906F0000000BOGHIA4
2) https://developer.salesforce.com/forums/?id=906F0000000BIZEIA4

Your Filter should be like below
User-added image


How to select
User-added image

Let us know if this will help you.


 
This was selected as the best answer
JyothsnaJyothsna (Salesforce Developers) 
Hi Babu,

No need to apply 2 separate filters for the second condition. Use only 1 filter and specify as follows:
Amount greater than "25,000" AND
Stage not equal to Closed Won,Closed Lost.


Hope this helps you!
Best Regards,
Jyothsna

 
Nisha BabuNisha Babu
Hi Jyothsa/Amit.

Thanks for helping in solving the issue.

With Regards,
    Nisha