Get Started with Redwood: Oracle Cloud SCM and Purchasing
Pending since how many days Report
Content
I need to make a report which has the following format. Since how many days is the incident in its current status. i.e. I want to calculate= count of (sysdate - max(Status change transaction) ) >1day.
Here since we cant take aggregate of aggregate in reports, I am not able to get the report.
|
Status |
0-1 days |
1-2 days |
2-3 days |
3-4 days |
4-5 days |
<5 days |
|
Waiting |
|
|
|
|
|
|
|
Updated |
|
|
|
|
|
|
Version
May 2015
Tagged:
0