Hi Reporting Gurus
Please someone give me a solution for my issue.
I have two keyfigures
Plan Finish Date(PFD)
Actual Finish Date(AFD)
I have one calculated keyfigure
Delivery Status = (AFD<=PFD) . When this condition is met it returns 1 else 0.
But Delivery Status = (AFD<=PFD) returns 1 if AFD and PFD both exists and if the condition is met and also works (returns 1) for the scenarios mentioned below.
1. if AFD is blank and PFD is filled
2. if AFD and PFD both is blank.
So I need a solution for my issue in such a way that
Delivery Status = (AFD<=PFD) should return 1 only if AFD and PFD both exists and only if AFD<=PFD.
For rest of all the scenarios my calculated keyfigure should return 0 , i.e.,
1.if AFD is blank and PFD is filled
2.if AFD and PFD both is blank.
3.if AFD is filled and PFD is blank.
How to achieve this?
Should I have to write a customer exit variable and incorporate ABAP codes or should I have to write VB macros or can we have a calculated keyfigure with a necessary logic or is there any other way to achieve it.
Please help me out.
Thanks in Advance,
Have a nice day
Regards
Sam