please see attached
is this what you expected
in each warehouse
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
WeblogX_v10.2.twbx 960.1 KB
The data shown after the calculation is incorrect.
Warehouse : 1133
Warehouse Name : RTC - Scrap House
Total no. of materials : 37
No. of materials present for more than 60 days : 36
Percent of materials present for more than 60 days : 97%
But according to your calculation, it is showing 17. And how is the both the total no. of materials and the materials present more than 60 days column values are same and also the percentage is 100 for all?
Please refer to the example.