on 09-20-2023 12:49 PM
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
User | Count |
---|---|
78 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.