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 .