Issue in expression

[#1]

Hi,

I'm not getting values in my drop down.

I want to display Transaction Status as 'Customer Reviewing Quote' when value is 'Quote Sent' and

Transaction Status as 'Conditional Approval' when value is 'TFS - Conditional Approval'

and default values for other values.

I wrote my expression as

if(wildmatch(([Transaction Status] = 'Quote Sent') , 'Customer Reviewing Quote'),

if(wildmatch(([Transaction Status] = 'TFS - Conditional Approval'), 'Conditional Approval'),[Transaction Status]))

Can some one please help me with this issue

Regards,

Aditya

[ali_hijazi]

you have a syntax error

you need to write if(wildmatch([Transaction Status],'Quote Sent')>0,Customer Reviewing quote',

if(wildmatch([Transaction Status],'tfs-conditional approval')>0,'Conditional Approval',[Transaction Status]))

[sunny_talwar]

Or a simpler version could be like this:

=If([Transaction Status] = 'Quote Sent', 'Customer Reviewing Quote',

  If([Transaction Status] = 'TFS - Conditional Approval', 'Conditional Approval', [Transaction Status]))

[#4]

Thank you SunIndia, it worked.

[sunny_talwar]

Awesome! I am glad that it worked

Best,

Sunny

[stigchel]

It would be better to do this in the load script with a mapping laod and Applymap functionality. In the gui you can use

=Aggr(Replace(Replace(TransactionStatus,'TFS - Conditional Approval','Conditional Approval'),'Quote Sent','Customer Reviewing Quote'),TransactionStatus)

See also attached