Skip to Content
0
Former Member
Nov 20, 2012 at 11:17 AM

Applying condition in Bex Query Designer

23 Views

Hi Experts,

I have a Characteristic in the Rows where it will give my Customer details like Name, Mobile No. Etc, and A Key figure in the Columns which calculates the Last/Recent billed date of that corresponding customer.

Now, I want to generate another Key figure where it has to check both the Characteristic and KF and Return a value according to that

For Example,

Name Mobile Last Bill Date(Calculated Key figure) 2nd KF

Customer 1 John 9908123456 20/04/2012 ?

Customer 2 Peter 123 08/05/2012 ?

Customer 3 Mark 9848123456 01/10/2011 ?

Customer 4 K 0000 15/09/2011 ?

Now when user executes the report by giving the input as 20/11/2012 (Cal day) , then value for the 2nd KF should generate as 1,2,3 and 4 for Customer 1,2,3 n 4 respectively.

Logic is, If the customer has Name and 10 digit Mobile No and Transacted with in last 12 Months then Value = 1.

If the customer doesn't has Name or 10 digit Mobile No and Transacted with in last 12 Months then Value = 2.

If the customer has Name and 10 digit Mobile No and didn't Transact with in last 12 Months then Value = 3

If the customer doesn't has Name or 10 digit Mobile No and didn't Transact with in last 12 Months then Value = 4.

Could anyone please guide me.

Thanks in advance,

Regards,

Anil.