function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
dinesh patil 7dinesh patil 7 

My challenge is showing error even though the report shows correct results

I am trying the report builder. 
I did complete the challenge and while checking it , it gives error even thought the report runs fine and gives desired result. 
I prepared with below logic for my report - 
Filter Logic:(1 AND NOT ( 2 OR 3))
1. Amount greater than ""25,000""
2. Stage equals "Closed Won"
3. Stage equals "Closed Lost"
The challenge is as given below - 
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.

And it keeps giving me error - 
Please check that you have a filter for Stages that are not equal to Closed Won or Closed Lost. 
 
Best Answer chosen by dinesh patil 7
Amit Chaudhary 8Amit Chaudhary 8
Can you please post screen shot of your report so that we can help you.

Filtered By: 1 AND 2
    1. Amount greater than "25,000" 
    2. Stage not equal to Closed Won,Closed Lost

User-added image

User-added image


Let us know if this will help you
 

All Answers

NagendraNagendra (Salesforce Developers) 
Hi Dinesh,

Please check below posts. I hope that will help you to solve the issue. User-added image

Please let us know if this will help you.

Regards,
Nagendra.
Amit Chaudhary 8Amit Chaudhary 8
Can you please post screen shot of your report so that we can help you.

Filtered By: 1 AND 2
    1. Amount greater than "25,000" 
    2. Stage not equal to Closed Won,Closed Lost

User-added image

User-added image


Let us know if this will help you
 
This was selected as the best answer
dinesh patil 7dinesh patil 7
This email reply helped me. I was adding separate filter for closed won and lost and doing 1 and (2or 3). So it was not working. Thanks for valuable support. Thanks, Dinesh Patil
NagendraNagendra (Salesforce Developers) 
Hi Dinesh,

May I suggest you please mark this as solved if it's resolved so that it gets removed from the unanswered queue and others can benefit from that.

Regards,
Nagendra.
dinesh patil 7dinesh patil 7
Nagendra and Amit,  your replies solved my query. Thanks.