Help with Query designer

[mohd_abdullah]

Dear  Experts
How can I achieve this in Query designer
I have many restricted key firures which holds date values which are as follows .

My requirement is to substract these key figures to get number of days the ticket was in particular status  as follows
FORMULA 1= Transaction date - Keys recd by FM  

Eg (01-01-2012 - 05-01-2012 = 5 days )
FORMULA 2= Key Rec. by FM - (FM Inspection Completed(if it has value) else it should be substrated
by "Transferred to Tenant Account " if blank then substract with "No Payment Due")

Thanks and Regards .

[anshu_lilhori · Accepted solution]

Hi,

For formla 1 you can simpy create a new formula and subtract the two dates this should give the difference.

For formual 2--- you need to make some conditions with the help of boolean operators in Bex.

(FM Inspection Completed) say FM--

Key Rec. by FM say KFM

Transferred to Tenant Account--sau TTA

(FM<>0)*(KFM-FM) + (FM==0)*(KFM-TTA)

third condition i did not get...

Hope this helps.

Regards,

AL

[mohd_abdullah · Accepted solution]

Hi Anshu

Thanks a lot for your  reply .

I got it now will finish the rest

Regards .

[Former Member]

Hi Mohammed,

In addition to what AL has already said, go through the below links for better understanding.

http://help.sap.com/saphelp_nw70ehp1/helpdata/en/23/17f13a2f160f28e10000000a114084/frameset.htm

Regards,

Sujit.

[mohd_abdullah]

Hey Sujit

Thanks man !!

Regards .