Skip to Content
0
Former Member
Dec 05, 2006 at 07:19 PM

help needed in creating a calculated keyfigure/query exit

21 Views

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