on 07-23-2010 9:41 AM
I am facing an issue in my project and require your suggestion for the same. The scenario is explained below -
A report has to be created over a DSO. The table looks similar to this:
Region Transaction Number Transaction Type Contract Start Date(CSD) Work Completion Date (WCD)
1 1000 ZRVP 01/01/2010 01/02/2010 1001 ZRVP 05/01/2010 18/02/2010
1001 ZRVF 05/01/2010 22/02/2010
1001 ZRVF 05/01/2010 26/03/2010
2 1002 ZRVP 04/04/2010 05/05/2010
BEx Report -
Service Calls have to be divided on the basis of the difference of ("Work completion Date"- "Contract Start Date")
Service call is calculates as -> ( (WCD-CSD) <10 )==1)* transactiontype Flag*51 , similarly for other date differences.
User wants a one liner report where he can see region wise report, without transaction numbers being displayed.
The output of the report should looks like this:
Region ServiceCall <10 days Service Calls 10 -20 days Service Calls20-30 days
But this does not gives correct result.
I am not sure how to calculate the date difference for individual transaction and still show it in the report without Transaction number getting populated at run time.
When i add the transaction number to the Rows section, the output is correct.
Any suggestions would really be appreciated.
Hi,
You may create one Formula/CKF to get the counter by putting If condidtion on your exsiting CKF/Formula.
Use this counter in display.
I hope it will help.
Thanks,
S
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks for the reply.
But i got the solution by making change in the DSO and adding the difference of Dates as new field and populating it by an ABAP program. This field is type CHAR and can be used with an restricted key figure along with another flag we already have.
So now i have count of number of transactions falling in specific time bracket, and hence can do calculations over it.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.