if else

[#1]

Hi All,

I have 2 tables

Table A

Customer no ¦   Product Numbers

10                             222222

11                             33234234

12                             4232434

Table B

Customer no ¦   Name   ! Addresss

12                            A

13                            B

14                             C

I have joined these 2 tables. based on Customer number.

Here in Table B we do not have data for customer number 10 and 11. so for this I need to show as if customer number is 10 then 'not present'  and customer number is 11 then 'Old Customer'

I tried in expression few things.. didn't work..

[#2]

yes settu ..it is static ..just some hard coded value. can I do this somewhere in expression also?

[settu_periasamy]

i think you can do the same in expression also. if you have the dimension as Customer Number, you can put the expression like below..

if(CustNo=10,'not present',

  if(CustNo=11,'Old Customer',Address))