Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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))
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
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))
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))
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
CAN U POST A SAMPLE QVW
Can you please post a sample app?