cancel
Showing results for 
Search instead for 
Did you mean: 

Using IF formula

cmorgan22
Member
0 Kudos

Hi! I have a report with 2 seperate tabs showing different information.

The first tabs report is showing me POs that we have received in, in the last 30 days. Date filter on this report is "Goods receipt date 'equal to' last 30 days begin".

The second tabs report is pulling the materials through from the first report and showing any other POs that have been accepted in previously. Some of these materials have had 2 or 3 deliveries etc etc. Date filter on this report is "Goods receipt date 'less than' 30 days begin".

Wondering whether there is a way that I can have a formula in the first tabs report to essentially say the below:

"If this material has been delivered in more than once, return result "MORE THAN ONCE""

Thanks

moshenaveh
Community Manager
Community Manager
0 Kudos

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Accepted Solutions (0)

Answers (0)