Need urgent replay

[#1]

Hi ,

I have one condition

if(GetFieldSelections(SOURCE)='A',Agent_Partner_Organization_Name_1,if(GetFieldSelections(SOURCE)='B',Agent_Partner_Organization_Name_2))

form the above condition if we select SOURCE = A then it will disply Agent_Partner_Organization_Name_1 and SOURCE = B then it will disply Agent_Partner_Organization_Name_2 , up to here working fine,

but my issue is if we don't select any thing it has to disply both columns data (Agent_Partner_Organization_Name_1 & Agent_Partner_Organization_Name_2)

please any one help me to get this

Thanks,

Sh

[tresesco]

Try:

if(GetFieldSelections(SOURCE)='A',Agent_Partner_Organization_Name_1,if(GetFieldSelections(SOURCE)='B',Agent_Partner_Organization_Name_2,Agent_Partner_Organization_Name_1 & Agent_Partner_Organization_Name_2))

[ariel_klien]

Hi,

Try

if(GetFieldSelections(SOURCE)='A',Agent_Partner_Organization_Name_1,if(GetFieldSelections(SOURCE)='B',Agent_Partner_Organization_Name_2),Agent_Partner_Organization_Name_1 &'-'& Agent_Partner_Organization_Name_2)

BR

Ariel

[nizamsha]

if(GetFieldSelections(SOURCE)='A',Agent_Partner_Organization_Name_1,

if(GetFieldSelections(SOURCE)='B',Agent_Partner_Organization_Name_2,

Agent_Partner_Organization_Name_1 & Agent_Partner_Organization_Name_2))

[Anonymous]

Hi,
You didn't give any result if you don't select anything, so your condition should be:

if(GetFieldSelections(SOURCE)='A',Agent_Partner_Organization_Name_1,if(GetFieldSelections(SOURCE)='B',Agent_Partner_Organization_Name_2,Agent_Partner_Organization_Name_1 & Agent_Partner_Organization_Name_2))

[#6]

Hi ,

Thanks for the reply,

But if we use above condition will get result side by side(if we don't select anything) (eg. Agent_Partner_Organization_Name_1=Amerias and Agent_Partner_Organization_Name_2=APJ will get result Amerias APJ), this is wrong for me , need to give the data like one column data ,

and those 2 columns are coming from same table

Is there any other way to get this?

Thanks ,

Sh

[nizamsha]

CAN U POST A SAMPLE QVW

[tresesco]

Can you please post a sample app?